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
Explain autonomous transaction.
How do I install microsoft sql?
How many subqueries can be nested in a statement?
Can we update views in sql?
What are packages in pl sql and also explain its advantages?
Can you selectively load only those records that you need? : aql loader
What is a primary key sql?
What is partition in sql query?
tell us something about heap tables. : Sql dba
How do I upgrade sql?
What is the difference between execution of triggers and stored procedures?
what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?
What is a parameter query?
What is self-join and what is the requirement of self-join?
Does db2 use sql?