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 procedure and function in sql?

980

What is cursor status?

1178

How do sql triggers work?

1024

Explain what is a view?

1046

What is nvl?

1055

What problem one might face while writing log information to a data-base table in pl/sql?

1140

what is self-join? : Sql dba

1132

What is index example?

995

what is the syntax used for partition in tsql? : Transact sql

999

Explain the difference between 'between' & 'and' operators in sql

985

Is truncate ddl or dml?

978

What is %s in sql?

1000

What does closing a cursor do?

1306

What are the different tcl commands in sql?

1153

What is difference between stored function and application function?

1178