select sal from (select sal from salary order by sal desc) where rownum &

Find out the 3rd highest salary?

Question Posted / tathagoto

Answer Posted / tathagoto

select sal from (select sal from salary order by sal desc)
where rownum <4;

Is This Answer Correct ?

1 Yes

4 No

Please Help Members By Posting Answers For Below Questions

What is hibernate and its relation to sql?

1126

define sql insert statement ? : Sql dba

1033

How does one load ebcdic data? : aql loader

1178

what is a unique key ? : Sql dba

1096

What is sql profiling in oracle?

1066

How do I audit the sql sent to the server?

1013

Is not null in sql?

1000

What can I use instead of union in sql?

970

Is primary key clustered index?

952

what are date and time functions in mysql? : Sql dba

980

What is difference between inner join and self join?

1088

Explain how to use transactions efficiently : transact sql

986

Is pl sql and postgresql same?

1138

Define union, minus, union all, intersect ?

1010

what is heap table? : Sql dba

1108