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

What is a sql schema used for?

1156

What do we need to check in database testing?

1066

What is the sql query to display the current date?

1094

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

1119

Explain the difference between sql and mysql.

1113

What is posting?

1086

How to run pl/sql statements in sql*plus?

1147

How many disk partitions should I have?

1042

What are different types of sql commands?

1204

How many triggers can be applied on a table?

989

Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

2070

How many row comparison operators are used while working with a subquery?

1073

What is the use of index in sql?

1068

Can you have a foreign key without a primary key?

1000

Can you skip header records while loading? : aql loader

1102