A table has 150 records. How do you retrieve 100th row to
120th row from that table ?
- 21 Answers
- 21930 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / mohan
select * from table_name where rownum between 100 and 120;
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
Do foreign keys improve performance?
how to return query output in html format? : Sql dba
What is t sql used for?
What is error ora-12154: tns:could not resolve the connect identifier specified?
define sql update statement ? : Sql dba
What is query syntax?
column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.
how is myisam table stored? : Sql dba
how many triggers are allowed in mysql table? : Sql dba
What is the difference between a primary key and a clustered index?
Define commit, rollback and savepoint?
What is sql used for?
When is the explicit cursor used ?
What does pl sql stand for?
How do I order by ascending in sql?
