select empno,sal from (select empno,sal from emp order by sal desc) whe

Find out the 3rd highest salary?

Question Posted / shruti

Answer Posted / shruti

select empno,sal from
(select empno,sal from emp order by sal desc)
where rownum<4

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is not null in sql?

580

Which is the correct statement about truncate and delete?

529

Can you upgrade sql express to full sql?

520

What is sequence in sql?

506

What is the primary use of normalization?

531

What is substitution variable?

583

How do you use join?

524

What is the use of sqlerrd 3?

521

Describe sql comments?

563

Does truncate require commit?

546

What is mdf ldf and ndf?

563

Can a foreign key have a different name?

515

What is materialized view. What are different methods of refresh?

783

What is compiled query?

522

What are the different types of dbms?

554