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.
- 24 Answers
- 24168 Views
- Mind Tree, I also Faced
- E-Mail Answers
Answer Posted / rohan
select empno from emp where (sal,deptno) in ( select max
(sal),deptno from emp where deptno in (10,20) group by
deptno)
| Is This Answer Correct ? | 13 Yes | 6 No |
Post New Answer View All Answers
Enlist the characteristics of pl/sql?
What do you understand by pl/sql cursors?
What is a loop in sql?
Mention what does plv msg allows you to do?
What is group by in sql?
What do you mean by stored procedures?
what is offset-fetch filter in tsql? : Transact sql
How do you use a while loop in pl sql?
how can we submit a form without a submit button? : Sql dba
Where do we use pl sql?
Why is a trigger used?
How do I find duplicates in sql?
What is difference between stored procedure and trigger?
Are subqueries better than joins?
how to dump a table to a file with 'mysqldump'? : Sql dba
