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 the life of an sql statement?

1076

how to install mysql? : Sql dba

1161

How can get second highest salary in sql?

1025

how to run 'mysql' commands from a batch file? : Sql dba

1170

Is a table valued function object?

1076

Is sql sequential or random?

1086

Which function is used to return remainder in a division operator in sql?

1201

How many types of relationship are there?

1082

what are the differences between binary and varbinary? : Sql dba

1085

What is the difference between pl and sql?

1153

Is left join faster than inner join?

1168

what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba

1019

What is informix sql?

1032

what are the advantages of mysql in comparison to oracle? : Sql dba

1048

Explain what is an index?

1104