LIMIT in MSSQL

[adrian_quah]

Guys, can u pls explain 2 me the meaning of this query: -

set rowcount $limit
select * from Table1 where pk in(
select top $total pk from Table1 order by pk desc )order by pk

what are: -
'rowcount'
'pk'
'top'

Thanks:rolleyes:

[adrian_quah]

Actually, what i want is to convert the following query which is Okay in MySQL to MS SQL Server query format..

SELECT * FROM customer_details order by 'Customer_ID' LIMIT 0, 10

Any help? thanx