select * from emp minus select * from emp where rownum <= (select count(

Select the Nth lowest value from a table?

Question Posted / venkat

Answer Posted / venkat

select * from emp minus select * from emp where rownum <= (select count(*) - &n from emp);

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to resolve the ORA-39133 error in Oracle?

1131

Explain the difference between sql and oracle?

1088

What are the data types in oracle?

1047

How to set up autotrace for a user account?

1062

what is dynamic SGA and static SGA

4426

How many types of tables are there in oracle?

1064

Explain compound trigger in oracle?

1047

What is a nvl function?

1038

How are extents allocated to a segment?

1136

What is raw datatype in oracle?

1145

What are the advantages of oracle 12c?

1183

what is the difference between restoring and recovering?

1018

what is difference between sql plus and sql*plus? (not sql and sql plus).

3909

what is normalisation?what are its uses?

2280

What happens if the imported table already exists?

1038