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
Please Help Members By Posting Answers For Below Questions
What is varray in pl sql?
How many types of indexes are there in sql?
What is pl sql architecture?
What are the qualities of 2nf?
Is left join same as join?
What is over () in sql?
What is t sql in sql server?
What is bulk collect in pl sql?
How many types of normalization are there?
What type of join is sql join?
What are the types of optimization?
Does inner join return duplicate rows?
Why do we use cursors?
what is normalization? : Sql dba
how to fetch common records from two tables? : Sql dba
