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

Does oracle roll back the transaction on an error?

1018

How can we debug in PL/SQL?

1137

Explain the types of joins in sql?

1035

What is minus?

1006

how are mysql timestamps seen to a user? : Sql dba

1139

What happens when a trigger is associated to a view?

915

Why is a primary key important?

1049

How do I start sql profiler?

1000

What is dynamic query?

981

what is a cursor? : Sql dba

1028

What are the types of dbms?

975

Which data type is a composite type?

991

How delete all data from table in sql?

1019

Is pl sql a programming language?

994

Is nosql relational?

947