Select emplid, sal from (select emplid, sal from emp_sal

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 / partha

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

Answer Posted / partha

Select emplid, sal from (select emplid, sal from
emp_sal_tbl where deptid = 10 order by sal desc) a where
rownum < 2
union
Select emplid, sal from (select emplid, sal from
emp_sal_tbl where deptid = 20 order by sal desc) a where
rownum < 2

Is This Answer Correct ?

0 Yes

4 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How many triggers can be applied to a table?

1123

Can we use views in stored procedure?

1084

What is mdf ldf and ndf?

1056

What are the different types of triggers?

1190

What is interval partition?

1099

What is indexing oracle sql?

1142

How to avoid duplicate records in a query?

1050

How sql query is executed?

1186

what is union? : Sql dba

1080

Why we use sql profiler?

1020

How much does sql certification cost?

1134

What is partition in sql query?

1044

What are different sql data types?

1125

How do I view a view in sql?

993

Does truncate release storage space?

1134