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 is difference between left and right outer join?
what is commit? : Sql dba
how do you login to mysql using unix shell? : Sql dba
Explain the difference between 'between' & 'and' operators in sql
How delete all records from table in sql?
What are pl sql procedures?
What is having clause in sql?
What is meant by <> in sql?
What is partition by in sql?
What is the use of double ampersand (&&) in sql queries? Give an example
what is meant by urlencode and urldocode? : Sql dba
What is the difference between left and left outer join?
What is oracle sql developer?
Is nosql faster than sql?
Can there be more than one function with a similar name in a pl/sql block?