Posted by Greg D. Moore \(Strider\) on 03/13/07 00:40

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

"Dmitry Kulinich" <dkul@isd.dp.ua> wrote in message
news:et4qcm$mf2$1@news.isd.dp.ua...

how to select 200 first records from table?

--
Thank you,
De Cool,
EPE

• Next in forum: Re: Scripted CREATE INDEX
• Prev in forum: Re: SQL to combine columns
• Thread view: Re: how to select 200 first records from table?

[Reply to this message]