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

Explain the the delete statements in sql?

1116

What is the difference between row level and statement level trigger?

1072

What is the advantage of nosql?

1114

Can we create a trigger on view?

946

What are sql*plus environment variables?

1155

mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql

1097

Why do we need pl sql?

1037

Explain lock escalation? : Transact sql

1270

What is Histogram?

1611

hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews

2062

Which command is used to call a stored procedure?

1055

Can we join same table in sql?

1068

How do you clear the screen in sql?

1124

How do I delete a trigger?

1015

What is sql integrity?

1248