select max(sal) from emp where sal<select max(sal) from emp

Write a query to find second highest salary of an employee.

Question Posted / monika

Answer Posted / monika

Is This Answer Correct ?

8 Yes

6 No

Please Help Members By Posting Answers For Below Questions

What is an index in sql with example?

919

what are the type of locks ? : Sql dba

898

what are the t string functions available in tsql? : Transact sql

945

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

958

How does one load ebcdic data? : aql loader

1093

what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?

2412

what are the disadvantages of mysql? : Sql dba

1075

How does pl sql work?

913

State some properties of relational databases?

1002

What is sql rowcount?

949

Is nosql faster than sql?

970

what is union? : Sql dba

965

what is dbms? : Sql dba

932

what are properties of a transaction? : Sql dba

1017

What are the string functions in sql?

923