Select Sal from Emp where Sal in (Select Max(Sal) from Emp)

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

Question Posted / manikumar

Answer Posted / manikumar

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

how many sql dml commands are supported by 'mysql'? : Sql dba

1058

how many columns can be used for creating index? : Sql dba

899

Can we use the cursor's to create the collection in PL/SQL?

961

Does pl sql work in mysql?

923

How to select unique records from a table?

1002

How to revise and re-run the last sql command?

1101

What is time based sql injection?

904

What is sql performance tuning?

868

what are the non-standard sql commands supported by 'mysql'? : Sql dba

1045

Does view contain data?

989

Can cursors be part of a trigger body?

1588

Is sql a dbms?

940

What is application trigger?

947

Is json a nosql?

917

Explain about various levels of constraint.

887