Answer Posted / anusha
select * from ars_mst_user where rownum<5
minus
select * from ars_mst_user where rownum<=3;
this query for retrive fourth row
same we can retrive any row
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what are tables and fields? : Sql dba
How do I create a sql database?
What are the different datatypes available in PL/SQL?
Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?
Why do we need cursor in pl sql?
Mention what are the benefits of pl/sql packages?
What is the difference between the sql*loader and import utilities? : aql loader
How delete all data from table in sql?
How do I run a pl sql procedure in sql developer?
Why is there a need for sqlcode and sqlerrm variables?
what is commit? : Sql dba
How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?
What is difference between left and right outer join?
What is sql partition?
What is raw datatype in sql?