select last_name,salary from employees where (salary,department

consider a table which contain 4 columns,ename,eno,sal and
deptno, from this table i want to know ename who having
maximum salary in deptno 10 and 20.

Question Posted / abhishekjaiswal

24 Answers
29547 Views
Mind Tree, I also Faced
E-Mail Answers

Answer Posted / abhishekjaiswal

select last_name,salary from employees where (salary,department_id) in ( select max(salary),
department_id from employees where department_id in (10,20) group by
department_id)
/
Output
LAST_NAME SALARY
------------------------- ----------
Hartstein 13000
Whalen 4400

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is #table in sql?

997

What is the difference between left join and right join?

889

ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..

2451

What packages(if any) has oracle provided for use by developers?

5718

What are pl/sql cursors?

991

What are the different schemas objects that can be created using pl/sql?

969

How can the performance of a trigger be improved?

993

Define SQL and state the differences between SQL and other conventional programming Languages?

1144

How does cross join work?

877

What is a left inner join?

948

What are pl sql procedures?

965

Can a trigger call a stored procedure?

1004

Explain unique key in sql.

944

What is compilation error in pl sql?

921

How do you modify a trigger?

876