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

Mention what does plv msg allows you to do?

1107

What is an example of translating a date into julian format?

1115

What is trigger and stored procedure in sql?

1029

What is the primary use of normalization?

1000

What is sqlservr exe?

974

What is an inner join sql?

1026

How to revise and re-run the last sql command?

1163

How to add new employee details in an employee_details table with the following details

1089

What is the starting oracle error number? What is meant by forward declaration in functions?

988

What are all the different normalization?

1037

What is sql and its types?

1180

How can I speed up sql query?

958

Could you please provide oca (oracle 10g) dumps for my certification ?

5156

Can a select statement fire a trigger?

1154

Why are aggregate functions called so?

946