select * from emp where rownum <=5 minus select * from emp where rownu

how to find 5th row ?

Question Posted / anil

Answer Posted / anil

select * from emp where rownum <=5 minus
select * from emp where rownum <5

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Mention what pl/sql package consists of?

935

What are the different datatypes available in PL/SQL?

1025

Is it possible for a table to have more than one foreign key?

967

Mention what is the function that is used to transfer a pl/sql table log to a database table?

929

What is a design view?

883

What is the difference between the conventional and direct path loads? : aql loader

1314

Why is the cursor important?

972

When sql appeared?

1022

What are the various restrictions imposed on view in terms of dml?

906

What is rank function in sql?

957

How to check if a column is nullable before setting to nullable?

1050

What trigger means?

925

Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?

1175

Why truncate is faster than delete?

1052

What does trigger mean in psychology?

911