SQlL-SERVER 2000's SQL 1

[kingz2000]

Hi,

I know with some SQL it is possible to find the top 5 from a list via the function 'top'. How can find the top 5 results ,say, using SQL-SERVER 2000??

ie SELECT TOP5(X) FROM TABLE_A ?????????

thanks for any help.

Kingz

 

[bborissov]

SELECT TOP 5 * FROM Table_A ORDER BY ?????

You must have ORDER BY clause.

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.

 

[kingz2000]

thank you!