select ename from emp where sal in(select max(sal) from emp) and deptno i

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

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

Answer Posted / avinash

select ename from emp where sal in(select max(sal) from
emp) and deptno in(10,20)

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the disadvantages of file system?

1268

What is the difference between union and union all command?

1094

How do I count duplicates in sql?

1113

Mention what problem one might face while writing log information to a data-base table in pl/sql?

1237

How long does it take to learn pl sql?

1064

What are the operators in sql?

1033

How many types of literals are available in pl sql?

1119

Explain scalar functions in sql?

1072

What is pl sql record in oracle?

1037

What is a join query?

969

What is a natural join sql?

983

How to take user input in pl sql?

1167

what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba

1072

What is a full join?

995

What is the maximum number of triggers, you can apply on a single table?

998