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 export your connection information to a file?

1133

How to bring a tablespace online?

1079

What are internal user account in oracle?

1008

Is oracle an operator?

923

How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?

3200

What is procedure overloading in oracle?

1061

What is Undo Management Advisor in Oracle?

1099

What do you understand by database schema and what does it hold?

1230

Explain the use of file option in exp command.

1131

What are the attributes that are found in a cursor?

1078

How to create a table index?

1151

What is a Garbage Collection? and what is full recursive Garbage collection?

2905

Explain the features of oracle?

1046

State the difference between a primary key and foreign key?

935

What are the common oracle dba tasks?

1149