A table has 150 records. How do you retrieve 100th row to
120th row from that table ?
- 21 Answers
- 24749 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / manjunath
select level from dual connect by level<=150
minus select from dual connect by level<=120;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do I tune a sql query?
What is number function in sql?
How can you fetch common records from two tables?
Does user triggers have entry for trigger with compilation errors?
what is top in tsql? : Transact sql
Does truncate free space?
what is the difference between undefined value and null value? : Sql dba
Can we call stored procedure in function?
how to shut down the server with 'mysqladmin'? : Sql dba
What is %s in sql?
what is 'mysqldump'? : Sql dba
How do I kill a query in postgresql?
What are the dml statements?
What is user defined functions?
how to get a list of columns in an existing table? : Sql dba
