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

What is difference between hql and native sql?

1124

What is a unique key?

1021

What is crud diagram?

902

How to get list of all tables from a database?

1129

How can I get the number of records affected by a stored procedure?

1027

What is the difference between a procedure and a function?

1052

How do I run sql?

1123

What is the difference between instead of trigger and after trigger?

971

What is varchar used for?

1050

Can we join same table in sql?

984

what is oracle database ? : Sql dba

993

How will you distinguish a global variable with a local variable in pl/sql?

1120

What is a memo field?

922

What is join view in sql?

918

What is a table?

984