Answer Posted / subhani
some of above have used corelated subqueries but it is not
recommonded to use.
best way is
select * from emp where rownum<=5
minus
select * from emp where rownum<5;
Is This Answer Correct ? | 11 Yes | 1 No |
Post New Answer View All Answers
What is application trigger?
How do you delete duplicates in sql query using rowid?
How do I know if I have sql express or standard?
Are there any features that are decommissioned in 11g that are not present in 11g?
What is number function in sql?
Can you selectively load only those records that you need? : aql loader
What is crud stand for?
what are the authentication modes in sql server? How can it be changed? : Sql dba
What is transaction control language (tcl)?
How do you update a table in sql?
What program will open a mdb file?
Is sqlite good enough for production?
How many tables can you join in sql?
Is clustered index a primary key?
How does one use sql*loader to load images, sound clips and documents? : aql loader