Try this select * from (SELECT empno,sal, DENSE

how to calcuate the second highest salary of he employee

Question Posted / eshwer

Answer Posted / eshwer

Try this
select * from (SELECT empno,sal, DENSE_RANK() OVER (ORDER BY sal desc) AS SalRnk
FROM scott.emp) where salrnk=2;

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Explain the the delete statements in sql?

1126

Is pl sql and postgresql same?

1185

Is sql harder than python?

1161

What is integrity in sql?

1111

What is trigger and types?

1074

What is sql partition function?

1303

what is 'trigger' in sql? : Sql dba

1153

How do you change a value in sql?

1081

What is sequence in sql?

1083

What is database white box testing and black box testing?

1164

What is difference between db2 and sql?

1054

What operating systems are supported by oracle sql developer?

1022

what are all the common sql function? : Sql dba

1113

Is it important to partition hard disk?

1078

Show the cursor attributes of pl/sql.

1116