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 are pl/sql packages?

1035

Can a procedure in a package be overloaded?

983

What is multiple columns?

1002

column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.

7138

What is varchar data type in sql?

1016

How is indexing done in search engines?

930

How do I install microsoft sql?

984

how to include character strings in sql statements? : Sql dba

1001

Can we group by two columns in sql?

946

How to run sql*plus commands in sql developer?

1085

Why we use joins in sql?

926

Can we delete column in sql?

1025

Explain ttitle and btitle.

1058

What is a table in a database?

993

What's the difference between inner join and left join?

949