Answer Posted / sunil bisht
Hi Shajin
above answere is perfectly correct.
but i have one more method..
select * from emp where rownum<6 minus select * from emp
where rownum<=4;
| Is This Answer Correct ? | 22 Yes | 3 No |
Post New Answer View All Answers
What is the difference among union, minus and intersect?
How to rename a table?
how can we know the count/number of elements of an array? : Sql dba
How would you reference column values before and after you have inserted and deleted triggers?
Why do we use joins?
What is trigger in pl sql with examples?
Name three sql operations that perform a sort.
What is the difference between unique and primary key constraints?
What is rownum in sql?
What is server name sql?
Why partition by is used in sql?
What are local and global variables and their differences?
What is the purpose of using pl/sql?
how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba
How do I view a table in sql?
