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

What are different sql data types?

1051

what are the join types in tsql? : Transact sql

1064

Are sql database names case sensitive?

1006

What is the least restrictive isolation level? : Transact sql

1069

What is gpt format?

940

What are the types pl/sql code blocks?

1134

What is sap sql?

982

What is pl/sql language case sensitive?

1127

name 3 ways to get an accurate count of the number of records in a table? : Sql dba

1067

what is self-join? : Sql dba

1164

What is the difference between syntax error and runtime error?

1142

how to delete an existing column in a table? : Sql dba

1005

Mention what are the benefits of pl/sql packages?

1082

What is a database? Explain

1112

What is sqlca in db2?

970