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 do you think about pl/sql?
what is the difference between nested subquery and correlated subquery?
How to start oracle sql developer?
What is difference between nchar and nvarchar?
How do you exit in sql?
Can 2 queries be executed simultaneously in a distributed database system?
what are the different type of normalization? : Sql dba
how to rename an existing column in a table? : Sql dba
How do sql databases work?
What is clustered index sql?
Can we have two clustered index on a table?
what is column? : Sql dba
what is commit? : Sql dba
how to drop an existing index in mysql? : Sql dba
what is a primary key? : Sql dba
