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

how to find the second highest salary from emp table?

Question Posted / winnie

Answer Posted / winnie

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

Is This Answer Correct ?

1090 Yes

131 No

Please Help Members By Posting Answers For Below Questions

What is a function in oracle pl sql?

1039

How many sql are there?

998

Why use triggers in sql?

957

What is pragma in pl sql?

1110

How to run pl sql program in mysql?

1021

How can I tell if sql is running?

1066

What is pl sql code?

1056

What kind of join is join?

972

What is the difference between database trigger and stored procedure?

1075

write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba

970

what is a constraint? : Sql dba

1172

How to look at the current sql*plus system settings?

1149

What are the parameter modes supported by pl/sql?

1108

Can a view be mutating? If yes, then how?

1028

How do I partition in sql?

964