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
Name the operator which is used in the query for pattern matching?
What is the difference between unique and primary key constraints?
How to assign sql query results to pl sql variables?
Explain the insert into statements in sql?
What is sql trigger example?
What is the basic form of sql query?
How to make a copy values from one column to another in sql?
Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.
What is sql*loader and what is it used for? : aql loader
What are different functions in sql?
How many postgresql users are there, worldwide?
Is oracel sql developer written in java?
Mention what is the function that is used to transfer a pl/sql table log to a database table?
Mention what are different methods to trace the pl/sql code?
what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba