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
30467 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 sqlite thread safe?

1054

what is column? : Sql dba

1004

How can you tell the difference between an index and a view?

937

Explain commit, rollback and savepoint.

1002

How to call a javascript function from pl sql?

1143

Why are aggregate functions called so?

947

Can we join more than 2 tables in sql?

1023

How to select 10 records from a table?

1158

What is benefit of creating memory optimized table?

973

What is case function?

1042

Can we create clustered index without primary key?

965

What are primary key and foreign key and how they work?

978

How can we link a sql database to an existing android app?

1030

What are the three forms of normalization?

1045

How to read/write files from pl/sql?

1036