A table has 150 records. How do you retrieve 100th row to
120th row from that table ?
- 21 Answers
- 24561 Views
- IBM, I also Faced
- E-Mail Answers
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 are the operators in sql?
Why is sharding used?
What are the benefits of triggers?
What is pl sql commands?
Why use triggers in sql?
What are tables and fields?
how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba
What is the difference between microsoft access and sql server?
What is normalisation and its types?
Which one is better subquery or joins?
What is a file delimiter?
What is information schema in sql?
What are sql constraints?
What are the types of triggers in sql?
What is the most restrictive isolation level? : Transact sql
