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 pl sql commands?
What is indexing in sql and its types?
What is pessimistic concurrency control? : Transact sql
Why is there a need for sqlcode and sqlerrm variables?
How do you explain an index?
what is a unique key ? : Sql dba
Which query operators in sql is used for pattern matching?
What is recursive join in sql?
What are instead of triggers?
What is pl sql block structure?
What is an exception in pl/sql?
Show how functions and procedures are called in a pl/sql block.
What is the difference among union, minus and intersect?
Explain select statements in sql?
What is a behavioral trigger?