Select emp_name from emp where sal =(Select Max(sal) from emp where deptn

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

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

Answer Posted / guest

Select emp_name from emp where sal =(Select Max(sal) from
emp where deptno=10) and deptno=10 union
Select emp_name from emp where sal =(Select Max(sal) from
emp where deptno=20)and deptno=20

Is This Answer Correct ?

6 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Is sqlite good enough for production?

950

What are different types of queries in sql?

1049

What is a procedure in pl sql?

1131

What is the use of pl/sql table?

998

What are few of the schema objects that are created using PL/SQL?

971

Are dml statements autocommit?

987

Explain what is a view?

998

What is the difference between truncate and drop statements?

1086

What are the three pl sql block types?

949

What is a table?

958

What is PL/SQL Records?

1116

What is left join example?

891

What is meant by user defined function?

988

how to decrement dates by 1 in mysql? : Sql dba

970

What are the triggers associated with image items?

1000