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
29811 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 is a sql profiler?

977

Is vs as in pl sql?

946

Why do we use procedures in pl sql?

983

what is msql? : Sql dba

960

Do triggers have restrictions on the usage of large datatypes, such as long and long raw?

1135

How to get list of all tables from a database?

1123

Which join condition can be specified using on clause?

916

What does cursor do in sql?

987

What are the possible values for the boolean data field?

922

What is cost in sql execution plan?

935

What is a temp table?

969

Can a composite key be null?

939

Can I create table without primary key?

955

What is scope of pl sql developer in future?

976

What is application trigger?

966