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
How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?
What are different types of statements supported by sql?
What is case function?
Which constraints we can use while creating database in sql?
What are the types of variable use in pl sql?
What is sql and also describe types of sql statements?
What is the difference between an inner and outer join?
how to increment dates by 1 in mysql? : Sql dba
What is the purpose of the partition table?
What are primary key and foreign key and how they work?
What is the sql case statement?
How do I find duplicates in a single column in sql?
What packages are available to pl/sql developers?
What is sql and explain its components?
What are the steps for performance tuning.