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 difference between rank () row_number () and dense_rank () in sql?

1120

How to set up sql*plus output format in oracle?

1046

What is tuple in sql?

1096

Why indexing is needed?

999

what is commit? : Sql dba

1085

how can you see all indexes defined for a table? : Sql dba

1010

What is substitution variable?

1061

i have some prob lem to tell me about my self in interview first round ...

2176

what is log shipping? : Sql dba

1132

What is integrity in sql?

1062

How do I create a sql database?

1013

What is the difference between alter trigger and drop trigger statements?

1122

Which sorts rows in sql?

1028

What is raid? How does it help storage of databases?

1095

What is scalar data type in pl sql?

1081