Fetching rows

[riya]

hi all,

This is a very urgent requirement.I need to fetch the last 10 rows of a table data.(no temporary tables must be used).
Thanx in advance

 

[Qaroven]

Assuming you want the last 10 records based on the value of field1 ..

select top 10 * from table1 order by field1 desc
Ben
+61 403 395 052

 

[Andel]

if you're using sql6.5, then use rowcount.

set rowcount 10
select * from names order by field1 desc




Andel
andelbarroga@hotmail.com

http://andyb.8m.com