select max(sal) from employee where sal<(select max(sal) from employee)

how to find the second highest salary from emp table?

Question Posted / prashanth

Answer Posted / prashanth

select max(sal) from employee where sal<(select max(sal)
from employee)

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How do you respond to dementia behavior?

970

What do you understand by pl/sql packages?

1058

Explian rowid, rownum?

1012

What is group function in sql?

1023

What is a table?

1015

Differentiate between sga and pga.

1164

What are stored procedures in mysql?

1019

What is difference between sql and excel?

1092

What is the use of primary key?

1008

What is a composite primary key?

1094

How much does sqlite cost?

1038

How do you determine the current isolation level? : Transact sql

1158

What is the least restrictive isolation level? : Transact sql

1068

What is java sql package?

1096

how to use 'mysql' to run sql statements? : Sql dba

1053