A table has 150 records. How do you retrieve 100th row to
120th row from that table ?
Answer Posted / arif hussain
select * from (
select ROW_NUMBER() over (order by tablename.columnname)as ronno,* from tablename )x
where ronno between 100 and 120
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is sql performance tuning?
What is a parameter query?
what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba
How much does sql cost?
Can you select everything, but 1 or 2 fields, without writer's cramp?
What is integrity in sql?
What is composite primary key in sql?
Which column of the user triggers data dictionary view displays the database event that will fire the trigger?
How to return multiple rows from the stored procedure?
What is data abstraction in sql?
how can we destroy the cookie? : Sql dba
What is primary key and unique key?
How do I sort a table in sql?
When do we use triggers?
What is the difference between union and union all command?