how to get top 100 records from a table

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

how to get top 100 records from a table

Author

Topic

ramu143
Yak Posting Veteran

64 Posts

Posted - 2008-05-06 : 03:54:21

i have cda table from that table i need get top 100 records

Anoop
Starting Member

6 Posts

Posted - 2008-05-06 : 03:56:30

SELECT TOP 100 *
FROM <table name>

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2008-05-06 : 03:56:53

Top 100 ordered by what? SQL does not have any concept of row position or insert order.

SELECT TOP 100 *
FROM SomeTable
Order by SomeColumn

--
Gail Shaw

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-05-06 : 04:01:41

Duplicate post :-
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=102260

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources