how to select 200 first records from table?

#1

how to select 200 first records from table?

--
Thank you,
De Cool,
EPE

#2

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 (AT) isd (DOT) dp.ua> wrote

how to select 200 first records from table?

--
Thank you,
De Cool,
EPE

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

how to select 200 first records from table?

comp.databases.ms-sqlserver comp.databases.ms-sqlserver

how to select 200 first records from table? - 03-12-2007 , 06:14 PM

Re: how to select 200 first records from table? - 03-12-2007 , 06:40 PM