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

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Selecting a number of rows only

Author  Topic 

Starting Member

34 Posts

Posted - 2001-07-31 : 03:28:10


Does anyone know how to select a certain number of rows only ? Lets say i select a table of 1000 rows but only want to fetch not more than 10 rows from the table, how can i make sure that only 10 are selected ? Now i have confused myself...



- Advertisement -