select * from (select ename, deptno,sal from emp where deptno in(10 , 20)

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

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

Answer Posted / sonal

select * from (select ename, deptno,sal
from emp where deptno in(10 , 20)
order by sal desc)
where rownum < =1

Is This Answer Correct ?

2 Yes

4 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are analytical functions in sql?

966

Can we use pl sql in sql server?

1008

Why we use triggers in mysql?

935

What is a record in pl/sql?

1064

Will truncate release space?

883

what is blob? : Sql dba

1050

Can a varchar be a primary key?

951

Explain the significance of the & and && operators in pl sql.

949

How many unique keys can a table have?

954

Is sql port 1433 encrypted?

968

Which are sql * plus commands?

1039

What are the basic sql commands?

1036

What is sql in oracle?

998

Why do we create stored procedures & functions in pl/sql and how are they different?

887

What is the advantage of nosql?

990