Select a Set of rows from a table

Please support our MS SQL advertiser: Intel Parallel Studio Home
Reply

Join Date: Jun 2008
Posts: 79
Reputation: varmadba is an unknown quantity at this point 
Solved Threads: 8
varmadba varmadba is offline Offline
Junior Poster in Training

Select a Set of rows from a table

 
0
  #1
Oct 1st, 2008
Say we have a table with 1000 rows
and there is no column which can identify a row(i mean no Identity or unique column)

now if we want to select a set of rows from this table how can we do that?

Ex: i want to select from rows 201 to 300

Please let me know if any one has any idea
:- Varma

We are Happy to inform launch of a new site with loads of database related information Site offers wide range of functionality Forums,Blogs,Articles,Editorials and much more
http://www.sqllibrarian.info/
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:


Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC