Getting top 10 - 15 record from 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

SQL Server 2000 Forums

Transact-SQL (2000)

Getting top 10 - 15 record from table

Author

Topic

mk_garg20
Constraint Violating Yak Guru

343 Posts

Posted - 2004-08-01 : 19:26:31

Hi All,
I want to get top 10 - 15 records from a table.
How i can do that.
Thanks

timmy
Master Smack Fu Yak Hacker

1242 Posts

Posted - 2004-08-01 : 19:28:39

SELECT TOP 10 fields...
FROM table

mk_garg20
Constraint Violating Yak Guru

343 Posts

Posted - 2004-08-01 : 20:43:18

Hi Timmy,
I got my answer from this link.
http://www.sqlteam.com/item.asp?ItemID=566 by graz
Thanks

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources