getting X records 2

[1DMF]

hello,

is there a way of selecting x number of records.

So i have a table and want to sort the table and then grab only the first 10 top records.

is this possible with a select statement?

thanks
1DMF

"In complete darkness we are all the same, only our knowledge and wisdom separates us, don't let your eyes deceive you.

 

[Rondrian]

hi,
that isn't really difficult:

select TOP 10 * from xyz order by [Name]

cya
andy

 

[bborissov]

SELECT TOP 10 .....
.....
ORDER BY ....

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
MVP VFP

 

[1DMF]

excellent - thanks a million guys

"In complete darkness we are all the same, only our knowledge and wisdom separates us, don't let your eyes deceive you.