select top 1 * from table where dept_no 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 pise

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

Answer Posted / swati pise

select top 1 * from table where dept_no 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

Is left join and outer join same?

1081

What is a data definition language?

1152

What are the events on which a database trigger can be based?

1200

What does plv msg allows you to do?

1152

What is a schema sql?

1161

What is sql exception?

980

What is assignment operator in pl sql?

1049

how tsql statements can be written and submitted to the database engine? : Transact sql

1007

What is crud diagram?

959

List the different type of joins?

1066

What is the use of function in sql?

1105

What does subquery mean in sql?

1062

What are different functions in sql?

951

What are the ddl commands?

1021

Can you inner join the same table?

1000