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 attribute indicator in pl sql?

985

What are the types of variables use in pl sql?

1001

Explain cursor types?

974

Why primary key is required?

964

What are literals in sql server?

1106

What is a trigger word?

982

What is join view in sql?

913

Name the different types of indexes in sql and define them.

1099

Is postgresql a nosql database?

1109

What is keys and its types?

1039

What are all the different normalizations?

997

How do you know if a relationship is 2nf?

895

What does closing a cursor do?

1273

How do you update a value in sql?

1007

which command using query analyzer will give you the version of sql server and operating system? : Sql dba

1015