A table has 150 records. How do you retrieve 100th row to
120th row from that table ?
Answer Posted / swapna
select * from emp where rownum<121
minus (select * from empwhere rownum<100);
| Is This Answer Correct ? | 11 Yes | 6 No |
Post New Answer View All Answers
What is set serveroutput on in pl sql?
What are character functions in sql?
Are stored procedures faster than queries?
How can we solve sql error: ora-00904: invalid identifier?
how to dump a table to a file with 'mysqldump'? : Sql dba
Can procedure in package be overloaded?
What are the popular database management systems in the it industry?
How do I remove sql plus from windows 10?
Can we use view in stored procedure?
What is package in pl sql?
Define join and name different types of joins?
How do you break a loop in pl sql?
what are the authentication modes in sql server? : Sql dba
Can cursors be part of a trigger body?
How can get second highest salary in sql?