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
- 24401 Views
- Mind Tree, I also Faced
- E-Mail Answers
Answer Posted / anil pednekar
select table1.ename from (select deptno, max(sal) as sal1
from table1 group by deptno having deptno in(1,2)) as T1,
table1 where T1.deptno=table1.deptno and
T1.sal1=table1.sal
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Can you rollback after commit?
What is union and union all keyword in sql and what are their differences?
Are there any features that are decommissioned in 11g that are not present in 11g?
Why do we use sql constraints? Which constraints we can use while creating database in sql?
How do I edit a stored procedure?
what is sql? : Sql dba
What is null in pl/sql?
how is myisam table stored? : Sql dba
What is sql integrity?
What is dba in sql? : SQL DBA
How many types of normalization are there?
How do I pipe the output of one isql to another?
What is the process of debugging?
What is rank () in sql?
What is sql query limit?
