all groups > sql server (alternate) > march 2007 >
You're in the

sql server (alternate)

group:

how to select 200 first records from table?



Re: how to select 200 first records from table? Greg D. Moore (Strider)
3/13/2007 12:40:49 AM
sql server (alternate):
SELECT TOP 200 <column list> from FOO ORDER BY <criteria>

--
Greg Moore
SQL Server DBA Consulting
Email: sql (at) greenms.com http://www.greenms.com

[quoted text, click to view]

how to select 200 first records from table?

--
Thank you,
De Cool,
EPE

how to select 200 first records from table? Dmitry Kulinich
3/13/2007 2:14:14 AM

how to select 200 first records from table?


--=20
Thank you,
De Cool,
AddThis Social Bookmark Button