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

State few characteristics of pl/sql?

931

Which is faster union or join?

904

What is sql used for?

1066

Is oracle sql free?

928

Is left join faster than inner join?

1065

how would you get the current date in mysql? : Sql dba

915

What is nosql example?

971

how many triggers are allowed in mysql table? : Sql dba

997

If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????

3947

Can a table contain multiple primary key’s?

1045

What is difference sql and mysql?

943

What is inner join in sql?

1004

What is dbo in sql?

921

Is time a data type in sql?

854

What is schema in sql example?

1091