Is it possible to select a particular number of rows from a table (assuming that the table does not has any Identity) without any “where” condition.
(for eg. cosider a table containing 100 rows and If I want to select first 10 records,we can use “select top 10 * from table_name”
Similarly,If I want to take the records between 50 and 60, What should I do?)
(If sub-Queries are used,It should not select the whole records from the table.)