select min(sal) from (select sal from emp order by sal desc) where rownu

find the third highest salary?

Question Posted / satish prajapati

Answer Posted / satish prajapati

select min(sal) from (select
sal from emp order by sal
desc) where rownum <= 3

Is This Answer Correct ?

2 Yes

4 No

Please Help Members By Posting Answers For Below Questions

What is the use of desc in sql?

938

Is coalesce faster than isnull?

926

What is a scalar value in sql?

1032

Explain how to use transactions efficiently : transact sql

948

How can we link a sql database to an existing android app?

1002

What is rollback?

1069

What is the difference between inner join and left join?

956

How do I copy a table in sql?

950

Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

913

How do you go back in sql?

960

Is sql an operating system?

983

What is the basic form of sql query?

908

How can triggers be used for the table auditing?

1037

How to add a column ‘salary’ to a table employee_details?

967

What are the 3 modes of parameter?

1131