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

Find out the 3rd highest salary?

Question Posted / shruti

51 Answers
73477 Views
BirlaSoft, DAC, Silvia Infotech, Sutra Infotech, I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is replication id?

921

Does sql profiler affect performance?

975

what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba

1022

What is union and union all keyword in sql?

1017

What is the difference between inner join and outer join?

972

Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

2101

Explain the difference between triggers and constraints?

961

Can we commit in trigger?

952

Compare sql & pl/sql

1102

What are the qualities of 2nf?

1022

What is trigger in sql?

1066

How is debugging done?

958

What is not in sql?

934

Is left join inner or outer by default?

1005

How many times can we commit in a loop?

998