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 the indexing methods?
What is difference between primary and secondary key?
what are the drivers in mysql? : Sql dba
what are the performance and scalability characteristics of mysql? : Sql dba
Explain the structure of pl/sql in brief.
how many tables will create when we create table, what are they? : Sql dba
How do you get column names only for a table (sql server)?
How to avoid using cursors?
What do you mean by query optimization?
Why do we need pl sql?
What are triggers and its uses?
How to display the records between two range in Oracle SQL Plus?
How do I tune a sql query?
Can we insert in sql function?
What are the three forms of normalization?