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

Is it possible to pass parameters to triggers?

1159

How can we implement rollback or commit statement in a trigger?

1084

what are the join types in tsql? : Transact sql

1102

What kind of join is join?

1009

What are string functions in sql?

1303

What is union, minus and interact commands?

1364

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

1092

What is spool?

1109

what is the difference between blob and text? : Sql dba

1062

define sql insert statement ? : Sql dba

1080

What are the set operators in sql?

1136

what is commit? : Sql dba

1124

What is a sql schema used for?

1153

Does access use sql?

1099

How can I change database name in sql?

1156