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
- 30483 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 rtm in testing?
What is the life of an sql statement?
What are the types of index in sql?
what is the difference between nested subquery and correlated subquery?
how can we optimize or increase the speed of a mysql select query? : Sql dba
What is dml statement?
What are the benefits of pl sql?
what is bcp? When is it used?
Could you please provide oca (oracle 10g) dumps for my certification ?
How delete all records from table in sql?
What is the difference between Union and Union all. Which is faster.
Why use triggers in sql?
How to rename a table?
How do you optimize a stored procedure query?
What are some predefined exceptions in pl/sql?
