select min(sal) from (Select sal FROM emp where rownum<=3 Order by

Find out the 3rd highest salary?

Question Posted / shaiju nair

Answer Posted / shaiju nair

select min(sal) from (Select sal
FROM emp where rownum<=3
Order by sal desc)

Is This Answer Correct ?

13 Yes

25 No

Please Help Members By Posting Answers For Below Questions

Are stored procedures faster than queries?

914

explain commit and rollback in mysql : sql dba

960

Write an sql query to select all records from the table?

988

What is materialized view in sql?

883

what is text? : Sql dba

1026

Does sql profiler affect performance?

963

What is substitution variable?

1017

Which is faster view or stored procedure?

899

Why procedure is used in sql?

995

what is difference between delete and truncate commands? : Sql dba

1078

define sql delete statement ? : Sql dba

982

Does oracle use sql?

895

What does (+) mean in sql joins?

1032

Is microsoft sql free?

1055

What is sp_helptext?

1026