A table has 150 records. How do you retrieve 100th row to
120th row from that table ?
Answer Posted / nayana
select * from emp where rownum<121
minus(select * from emp where rownum<100)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the disadvantages of not performing database normalization?
What are the different types of sql commands?
What is parameter substitution in sql?
How do you select unique values in sql?
How do I count duplicates in sql?
what does myisamchk do? : Sql dba
What is a left join?
Why do we use sqlite?
What is gpt format?
What is bulk collect in pl sql?
How many types of relationship are there?
Why is %isopen always false for an implicit cursor?
How many primary keys can a table have?
what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba
Describe sql comments?