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 the requirement of self-join?
What are the advantages of pl sql?
How do I access sql anywhere database?
what is not null constraint? : Sql dba
What happens when a trigger is associated to a view?
What do you mean by rowid?
What is union and union all keyword in sql?
How many sql are there?
Mention what is the function that is used to transfer a pl/sql table log to a database table?
What is meant by cursor in sql?
What are the different dcl commands in sql?
What is difference between sql and mysql?
What does 0 mean in sql?
What do you mean by table in sql?
What is the difference between delete, truncate and drop command?