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

Where do we use pl sql?

982

Why should I use postgresql?

998

What is the use of double ampersand (&&) in sql queries? Give an example

1122

What do you mean by stored procedures? How do we use it?

979

How can we make an if statement within a select statement?

997

What does closing a cursor do?

1300

What is the difference between function, procedure and package in pl/sql?

1219

what is column? : Sql dba

988

Which tcp/ip port does sql server run on? How can it be changed? : Sql dba

978

what is rdbms? : Sql dba

997

What is sql clause?

1033

What are two statement types in sql?

1064

How do I view tables in sql developer?

920

Does varchar need length?

978

What are the commands used in sql?

1047