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 the syntax and use of the coalesce function?

606

How do you create a unique index?

575

What is pl sql architecture?

504

what is foreign key? : Sql dba

589

Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql

535

What does cursor do in sql?

521

what is the functionality of the function htmlentities? : Sql dba

525

Is sql developer case sensitive?

522

Is inner join faster than left join?

640

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

680

Why do we need view in sql?

553

What is clustered and nonclustered index in sql?

504

What is foreign key sql?

557

What version is sql?

555

How do you optimize a query?

540