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
- 29556 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
Why do we need cursors in pl sql?
How to create a menu in sqlplus or pl/sql?
How do I quit sql?
how to select unique records from a table? : Sql dba
What is sql stand for?
Explain the difference between cursor declared in procedures and cursors declared in the package specification?
What is full join in sql?
What is rownum in sql?
Is it possible to pass parameters to triggers?
What are the features of pl sql?
How much does sql certification cost?
Why use truncate instead of delete?
What is an oracle stored procedure?
What is acid property in a database?
What is data profiling in sql?
