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

how to find the second highest salary from emp table?

Question Posted / muhammed zaheer

Answer Posted / muhammed zaheer

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

Is This Answer Correct ?

86 Yes

16 No

Please Help Members By Posting Answers For Below Questions

Is it possible to pass parameters to triggers?

1159

How to get list of all tables from a database?

1209

Explain about various levels of constraint.

1000

What is oracle pl sql developer?

1024

What is the difference between sql and t sql?

1106

What do you understand by case manipulation functions?

1079

How can you view the errors encountered in a trigger?

1022

how to use case expression? : Sql dba

1078

What are the different types of sql commands?

1176

List the ways to get the count of records in a table?

942

What are crud methods?

1084

What is AUTH_ID and AUTH_USER in pl/sql ?

2233

Explain the significance of the & and && operators in pl sql.

1046

How do I run a sql query in pgadmin 4?

999

Does postgresql run on the cloud?

1222