select max(e1.salary) from Emp_table e1 where e1.salary not in (select max

how to find the second highest salary from emp table?

Question Posted / mohan rathour

Answer Posted / mohan rathour

select max(e1.salary) from Emp_table e1 where e1.salary not
in (select max(e2.salary) from Emp_table e2 )

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

how to check server status with 'mysqladmin'? : Sql dba

1134

What does count (*) mean?

986

how many columns can be used for creating index? : Sql dba

989

What does select count (*) mean in sql?

1075

What is the use of non clustered index?

1046

How do I copy a table in sql?

1037

What are some predefined exceptions in pl/sql?

1226

How do you select unique values in sql?

1049

What is the use of function "module procedure" in pl/sql?

1240

What are different types of sql commands?

1204

How do I run a sql query in pgadmin 4?

1002

Is a foreign key always unique?

984

Can we join two tables without common column?

1062

Is ms sql traffic encrypted?

963

what is subquery? : Sql dba

1190