select * from employee where salary=(select max(salary) from employee wher

how to find the second highest salary from emp table?

Question Posted / vijay shegokar

Answer Posted / vijay shegokar

select * from employee where salary=(select max(salary) from
employee where salary not in (select max(salary) from
employee));

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is query syntax?

963

What is assignment operator in pl sql?

1033

Can we commit in trigger?

974

What are the dml statements?

1141

Which join is like inner join?

1025

How can I make sql query run faster?

1011

How do you explain an index number?

1099

How show all rows in sql?

1011

what are the different functions in sorting an array? : Sql dba

1014

What is range partitioning?

962

What are properties of the transaction?

998

how to analyze tables with 'mysqlcheck'? : Sql dba

1013

What is sharding in sql?

973

Explain normalization and what are the advantages of it?

951

What is latest version of sql?

1042