Forums
This topic is locked
Display first 10 record only
Posted 26 Feb 2002 04:08:23
1
has voted
26 Feb 2002 04:08:23 agoes Setiawan posted:
Hallo,What is SQL syntact to display first 10 records on database table.
Thank you
Replies
Replied 26 Feb 2002 13:58:47
26 Feb 2002 13:58:47 Owen Eastwick replied:
SELECT TOP 10 * FROM TableName
or
SELECT TOP 10 FisrtField, Secondfield FROM TableName
You can specify a percentage as well:
SELECT TOP 20 PERCENT * FROM TableName
Regards
Owen.
Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo
or
SELECT TOP 10 FisrtField, Secondfield FROM TableName
You can specify a percentage as well:
SELECT TOP 20 PERCENT * FROM TableName
Regards
Owen.
Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo