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

How do I run a sql query in pgadmin 4?

904

what is sql profiler? : Sql dba

994

Which data type is a composite type?

931

What is trigger point?

947

Which data dictionary views have the information on the triggers that are available in the database?

1179

How do I edit a stored procedure?

945

What does pl sql developer do?

878

Is ms sql is free?

948

Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?

2226

How to take user input in pl sql?

1105

What are the subsets of sql?

1032

Why do we use %rowtype & %type in plsql?

991

What is full join in sql?

937

how to use 'mysql' to run sql statements? : Sql dba

982

How do I tune a sql query?

933