select salary from emp where salary=(select max(salary) from emp)

how to find the n'th highest salary from emp ?

Question Posted / sunil panghal

Answer Posted / sunil panghal

select salary from emp where salary=(select max(salary)
from emp)

Is This Answer Correct ?

6 Yes

23 No

Please Help Members By Posting Answers For Below Questions

What is oracle join syntax?

572

How to define a cusotmer as a supplier in ORACLE R12

1728

State the difference between a primary key and foreign key?

518

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

577

Explain the difference between replace() and translate() functions in oracle?

582

How to pass a parameter to a cursor in oracle?

597

What is data type in oracle?

566

What is the difference between a hot backup and a cold backup in oracle?

577

Explain about functional dependency and its relation with table design?

556

Why do you use stored procedures and state some of its disadvantages?

567

What are the differences between date and timestamp in oracle?

554

How can I introduce multiple conditions in like operator?

558

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

1812

Is oracle a language?

528

State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.

609