3rd highest salary: select max(sal) from emp where sal

find out the third highest salary?

Question Posted / santanu

Answer Posted / santanu

3rd highest salary:

select max(sal) from emp
where sal < (select max(sal) from emp
where sal < (select max(sal) from emp))

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What the is the diff between local index and global index. give some example.

1589

How to create a stored procedure in oracle?

1028

What is dual table oracle?

927

What do you understand by a database object?

990

How to get maxsal , minsal, ename department wise in single query

1501

What happens if the update subquery returns multiple rows?

1046

What is a private synonym?

1531

What is clustered table in Oracle?

1108

How to compare dates in oracle sql?

1043

What is the purpose of save points in oracle database?

1007

How to bring a tablespace offline?

1001

How to write date and time interval literals in oracle?

974

Can you assign multiple query result rows to a variable?

933

How to convert numbers to characters in oracle?

971

Explain the dml?

921