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
- 31215 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
What if we write return in procedure?
Can you select everything, but 1 or 2 fields, without writer's cramp?
Explain how can you save or place your msg in a table?
What is sql rowcount?
What are the different datatypes available in PL/SQL?
What are the various levels of constraints?
How global cursor can be declare with dynamic trigger ?
Can I learn sql in a week?
What is offset and limit in sql?
Explain constraints in sql?
What is bulk compiling in pl/sql.?
How can we avoid duplicating records in a query?
How do temporal tables work?
how to enter binary numbers in sql statements? : Sql dba
How to use transactions efficiently : transact sql
