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
Why sql query is slow?
How does postgresql compare to oracle/db2/ms sql server/informix?
What are the parts of a basic sql query?
how to include numeric values in sql statements? : Sql dba
How do I count rows in sql?
What is sql partition function?
What are the triggers associated with image items?
How do I find sql profiler?
How do I pipe the output of one isql to another?
What is data type in sql?
What is query optimization in sql?
What are the most important ddl statements in sql?
Why do we need pl sql?
Does inner join remove duplicates?
How does cross join work in sql?