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
Is id a reserved word in sql?
how do you control the max size of a heap table? : Sql dba
What are the advantages of indexing?
What do you mean by query optimization?
what is a scheduled jobs or what is a scheduled tasks? : Sql dba
Which is faster count (*) or count 1?
What is sql analyzer?
what are all the common sql function? : Sql dba
What are primary key and foreign key and how they work?
Why do we need databases?
Can we use joins in subquery?
how to shut down the server with 'mysqladmin'? : Sql dba
How can a pl sql block be executed?
What is localdb mssqllocaldb?
How do you change a value in sql?