select max(salary) from emp where salary not in (select max(salary) from

how to find the second highest salary from emp table?

Question Posted / ajeshanath

Answer Posted / ajeshanath

select max(salary) from emp where salary not in
(select max(salary) from emp)

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Explain the working of primary key?

1093

explain commit and rollback in mysql : sql dba

1011

When do we use triggers?

1074

How to install oracle sql developer?

1042

what is “go” in t-sql? : Transact sql

1104

Does postgresql run on the cloud?

1144

what are the advantages and disadvantages of cascading style sheets? : Sql dba

1060

Can you do multiple joins in sql?

1049

How many types of triggers exist in pl/sql?

1065

What is informix sql?

975

How much does sql cost?

995

Define concurrency control. : Transact sql

1185

What jobs use sql?

980

Explain the the delete statements in sql?

1059

Name three sql operations that perform a sort.

1003