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

how to rename an existing column in a table? : Sql dba

1033

What does pl sql stand for?

1125

What is a native sql query?

1094

explain commit and rollback in mysql : sql dba

1031

What is scalar and vector?

1017

What is the purpose of the sql select top clause?

1127

Which table is left in left join?

1030

Is ms sql traffic encrypted?

931

what is online transaction processing (oltp)? : Sql dba

1004

What is the left table in sql?

978

What is snowflake sql?

1082

How do I run pl sql in sql developer?

1131

What do you understand by exception handling in pl/sql?

1042

Can we change the table name in sql?

953

Is sql workbench free?

1010