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
- 26756 Views
- Mind Tree, I also Faced
- E-Mail Answers
Answer Posted / purushotham
select ename from table where sal in
(select max(sal) from table_name
where deptno in ('10','20')
group by deptno);
| Is This Answer Correct ? | 16 Yes | 8 No |
Post New Answer View All Answers
What is user in sql?
What is dcl in sql?
Which function is used to return remainder in a division operator in sql?
what is sql? : Sql dba
Can you join views in sql?
Can we use rowid as primary key?
Why are cursors used?
How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?
What is a behavioral trigger?
What are the different sql commands?
How do I use google cloud in sql?
Why do we create views in sql?
What is sql in java?
What is sqlservr exe?
Can we use join in subquery?
