Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Select * & return top 100 rows

Status
Not open for further replies.
biglebowski

biglebowski

Technical User
Jan 29, 2004
3,117
GB
Is it possible to run the "select * from table" and only return the top 100 results. The same as you can in enterprise manager when right clicking the table and choosing return top 100 results?

When I was born I was so suprised I didn't talk for 18 months
 
Sort by date Sort by votes
Code: 
select top 100 * from table

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

1DMF
  • Locked
  • Question
Management Studio & Localhost 1
Replies
2
Views
116
1DMF
1DMF
dexterdg
  • Locked
  • Question
SQL SERVER: Query to get the last instance of an ID but return the first instance of that ID
Replies
2
Views
104
dexterdg
dexterdg
baran121
  • Locked
  • Question
no backupset selected to be reload
Replies
0
Views
60
baran121
baran121
TheBugSlayer
  • Locked
  • Question
Need to restore 200 millions rows from 400-million-row archive table, fast!
Replies
7
Views
49
TheBugSlayer
TheBugSlayer
denacho
  • Locked
  • Question
SQL Express 2008 database full backups & trans logs
Replies
5
Views
81
denacho
denacho

Part and Inventory Search

Sponsor

Back
Top