select ename from table where sal=(select max(sal) from table) and depetn

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

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

Answer Posted / srilekha

select ename from table where sal=(select max(sal) from
table) and depetno in (10,20)

Is This Answer Correct ?

27 Yes

20 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Why use truncate instead of delete?

960

what is the difference between $message and $$message? : Sql dba

943

What is sql and db2?

941

What is an inner join sql?

955

how do you know the version of your mysql server? : Sql dba

935

How do you know if a relationship is 2nf?

877

What is optimistic concurrency control? : Transact sql

940

What is oracle sql called?

863

Are subqueries faster than joins?

949

what are set operators in sql? : Sql dba

983

What is package in pl sql?

961

What is the process of debugging?

1001

Why is normalization important?

971

Is null operator in sql?

978

What is relationship? How many types of relationship are there?

1070