select max(sal) from emp where sal <(select max(sal) from emp);

how to find the second highest salary from emp table?

Question Posted / sudha

Answer Posted / sudha

select max(sal) from emp where sal <(select max(sal) from
emp);

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Explain what is rdbms?

1028

where are cookies actually stored on the hard disk? : Sql dba

1026

How do I remove sql developer from windows 10?

1102

How can we avoid duplicating records in a query?

978

Does view store data in sql?

960

What programs use sql?

1000

Which tcp/ip port does sql server run?

998

What packages(if any) has oracle provided for use by developers?

5807

What does sql stand for?

986

What is numeric function sql?

1054

What is structural independence and why is it important?

1028

What is record data type?

908

What is the difference between clustered and non-clustered indexes?

1085

How to make a copy values from one column to another in sql?

1031

What is left join in postgresql?

1044