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

how to convert character strings to dates? : Sql dba

1094

Is inner join same as self join?

1163

Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

1003

What is sql resultset?

1036

What is plpgsql language?

1135

What is nvl?

1107

What are the different types of dbms?

1058

What is a unique key?

1103

what is the use of friend function? : Sql dba

1056

Is pl sql a programming language?

1038

what is the difference between group by and order by in sql? : Sql dba

1181

What is sp_helptext?

1105

What is sql injection vulnerability?

1003

How can the performance of a trigger be improved?

1087

what is row? : Sql dba

1274