Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 29826 Views
- Mind Tree, I also Faced
- E-Mail Answers
Answer Posted / praveen reddy.eddula
select ename from emp where sal in(select max(sal) from emp
where deptno in(10,20))
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the different types of triggers?
What is a trigger in sql?
Why do you partition data?
what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba
What is dynamic sql in pl sql?
Is it possible to include an insert statement on the same table to which the trigger is assigned?
How to select unique records from a table?
What is a natural join?
How do you concatenate in sql?
What is sqlerrm?
How do I clear the screen in sql plus?
define data blocks ? : Sql dba
Is postgresql a nosql database?
Sql technical questions
What are the various levels of constraints?
