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
- 31211 Views
- Mind Tree, I also Faced
- E-Mail Answers
Answer Posted / guest
Select emp_name from emp where sal =(Select Max(sal) from
emp where deptno=10) and deptno=10 union
Select emp_name from emp where sal =(Select Max(sal) from
emp where deptno=20)and deptno=20
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
What is lexical units in pl sql?
How to make a copy values from one column to another in sql?
What does bitemporal mean?
Explain the purpose of %type and %rowtype data types?
What is primary and foreign key?
What is a procedure in pl sql?
Can delete statement be rollbacked?
What is rownum in sql?
Can we use joins in subquery?
When are we going to use truncate and delete?
What is the difference between local variables and global variables?
What is sql clause?
what is a join? : Sql dba
Why is a trigger used?
How many types of sql are there?
