A table has 150 records. How do you retrieve 100th row to
120th row from that table ?
Answer Posted / sravan
select * from emp where rownum<151
minus(select * from emp where rownum<121)
| Is This Answer Correct ? | 13 Yes | 14 No |
Post New Answer View All Answers
Why do we create views in sql?
What is java sql connection?
What is a stored procedure in sql with example?
What are the different ddl commands in sql?
explain the advantages and disadvantages of stored procedure? : Sql dba
Enlist some predefined exceptions?
What is trigger explain it?
What are the sql aggregate functions?
What is cartesian join in sql?
what is 'mysqlshow'? : Sql dba
What is the cause of mutating table error and how can we solve it?
How does pl sql work?
Is nosql faster than sql?
Is it mandatory for the primary key to be given a value when a new record is inserted?
how can we submit a form without a submit button? : Sql dba