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 join two tables in a single query using oracle?

1054

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

2194

What do you understand by a database object? Can you list a few of them?

1066

What are the various types of snapshots ?

1083

Explain the truncate in oracle?

1013

what are actual and formal parameters?

1159

How to view the data files in the current database?

1151

What is truncate oracle?

1016

What is the minimum client footprint required to connect c# to an oracle database?

1162

How to store only time; not date and time?

1070

what are bitmap indexes? How does they work?

2306

What is oracle instant client?

1069

How to convert times to characters in oracle?

1072

Is there a combination of "like" and "in" in sql?

1116

how can db_files > maxdatafiles since db_files is for instance and the later is for database

2675