select top 1 ename from emp where deptno in(10,20) order by sal desc

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

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

Answer Posted / swati

select top 1 ename from emp where deptno in(10,20) order by
sal desc

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How can get second highest salary in sql?

967

where are cookies actually stored on the hard disk? : Sql dba

1020

how many tables will create when we create table, what are they? : Sql dba

1057

What is pl sql collection?

950

list out some tools through which we can draw e-r diagrams for mysql. : Sql dba

955

What is an intersect?

1091

What port does sql server use?

1047

What are data types in pl sql?

1126

What is the basic form of sql query?

927

Can a composite key be null?

963

What is the difference between cluster and non-cluster index?

1096

Explain commit, rollback and savepoint.

983

what are all the common sql function? : Sql dba

1048

Determine if oracle date is on a weekend?

1029

What does over partition by mean in sql?

960