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
30193 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

How to process query result in pl/sql?

1105

tell me about various levels of constraint. : Sql dba

1026

Explain the the update statement in sql?

1015

What is record type in pl sql?

977

Write a sql query to find the names of employees that begin with ‘a’?

991

how to enter characters as hex numbers? : Sql dba

1024

What is identity column in sql server?

1035

What is an escape character in sql?

1009

What is exit statement?

1000

Why do we use sql constraints? Which constraints we can use while creating database in sql?

1022

Explain the steps needed to create the scheduled job?

1023

What are database links used for?

1029

Can we use update in sql function?

1046

what is the difference between rownum pseudo column and row_number() function? : Sql dba

1060

Which tcp/ip port does sql server run?

989