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

List out the types of joins.

589

Can objects of the same schema reside in different tablespace?

583

What do you mean by merge in oracle and how can we merge two tables?

575

What are the execution control statements?

610

What is a nested table?

626

Can we create database in oracle using command line ?

580

What is oracle rowcount?

571

What is difference between sid and service name in oracle?

512

What is tns entry?

619

Is a rollback possible to any savepoint?

555

Explain the use of rows option in imp command.

604

Why do we use coalesce function in oracle?

625

What are the extensions used by oracle reports?

571

Explain the types of exception?

648

What is flashback in Oracle?

581