Use the below Query: Select Max(salary) from Emp Where Max(salary) <

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

Question Posted / amol londhe

Answer Posted / amol londhe

Use the below Query:

Select Max(salary) from Emp
Where Max(salary) < (Select Max(salary) from emp
where emp-no=101);

Is This Answer Correct ?

10 Yes

18 No

Please Help Members By Posting Answers For Below Questions

What is sqlerrd?

968

How does a covering index work?

958

Why truncate is used in sql?

1003

what are the authentication modes in sql server? : Sql dba

1060

What is blind sql injection?

1071

What is sql*loader and what is it used for? : aql loader

1174

Are dml statements autocommit?

1045

What is exit statement?

1013

what are local and global variables and their differences? : Sql dba

1070

What are different types of triggers?

1110

Show the two pl/sql cursor exceptions.

1193

What is trigger price?

986

Can we use distinct and group by together?

1054

What is mutating table error?

1178

what is online transaction processing (oltp)? : Sql dba

994