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

What is a recursive stored procedure?

1254

what is the difference between myisam static and myisam dynamic? : Sql dba

1116

What are %type and %rowtype for?

1109

What is a design view?

978

define sql delete statement ? : Sql dba

1069

what is a control file ? : Sql dba

1092

Can we use rowid as primary key?

1046

What is the difference between joins?

1094

What is exit statement?

1064

Why query optimization is needed?

975

Can we edit a view in sql?

1047

How do I run a program in pl sql?

1055

Can you join a table to itself?

1225

Which command is used to call a stored procedure?

1055

What is the difference between delete and truncate commands?

1100