select * from emp where sal=(select max(sal) from emp where sal not in(se

how to find the second highest salary from emp table?

Question Posted / sankar

Answer Posted / sankar

select * from emp where sal=(select max(sal) from emp where
sal not in(select max(sal) from emp))

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Can there be more than one function with a similar name in a pl/sql block?

1044

what is column? : Sql dba

1053

What is varray in pl sql?

1123

What is trigger with example?

1170

If a cursor is open, how can we find in a pl/sql block?

1216

Why do we use procedures?

1007

How to write html code in pl sql?

1161

Why do we need a foreign key?

1168

Are pl sql variables case sensitive?

1093

Why functions are used in sql?

1044

What is a native sql query?

1171

What is the difference between syntax error and runtime error?

1185

Is foreign key mandatory?

1064

Can we use distinct and group by together?

1107

What are records give examples?

1054