select max(salary) from employee where salary!=(select max (salary) from e

how to find the second highest salary from emp table?

Question Posted / sathiavathi

Answer Posted / sathiavathi

select max(salary) from employee where salary!=(select max
(salary) from employee);

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Explain the the delete statements in sql?

1059

what is the difference between sql and t-sql? : Transact sql

1084

what is transaction? : Sql dba

1007

Define implicit and explicit cursors.

1144

What is data profiling in sql?

1074

Which version of sql do I have?

1054

How do I use google cloud in sql?

1084

Explain what is rdbms?

1028

How many clustered indexes can be created on a table?

1075

Define commit, rollback and savepoint?

1025

What is t sql in sql server?

1072

What is %type in sql?

965

What is hibernate and its relation to sql?

1119

What is the difference between function and procedure in pl/sql?

1081

How is sql used in oracle?

1003