select max(salary) from emp where salary < (select max (salary) from em

how to find the second highest salary from emp table?

Question Posted / moharaj m

Answer Posted / moharaj m

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

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Can you inner join the same table?

1039

What is the reports view in oracle sql developer?

1046

Can we create a trigger on view?

946

how to escape special characters in sql statements? : Sql dba

1084

Does sap use sql?

1042

Is clustered index a primary key?

990

What is microsoft t sql?

986

Can I learn sql in a week?

1122

Why is the cursor important?

1082

What is sql profiler in oracle?

1162

How do I run a query in pl sql developer?

1053

how to fetch alternate records from a table? : Sql dba

1172

what is 'mysqlimport'? : Sql dba

1115

Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?

3624

What is the difference between delete and truncate statement in sql?

1131