Interested to Buy Any Domain ? << Click Here >> for more details...
two tables are there
emp(eno,ename,sal,deptno),dept(deptno,dname).how form the
query in deptno,ename,max(sal)
- 2 Answers
- 4973 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ajit
select e.ename,d.deptno,max(e.sal)
from emp e, dept d
where e.deptno = d.deptno
group by e.ename, d.deptno;
| Is This Answer Correct ? | 4 Yes | 2 No |
Answer / no_name
select deptno,dname,max(sal) dept_max
from
(select empno, e.deptno, d.dname, e.sal
from emp e,
dept d
where e.deptno = d.deptno)
group by deptno,dname;
| Is This Answer Correct ? | 2 Yes | 2 No |
What is a cognitive schema?
How can we force the database to use the user specified rollback segment?
when a grant option is encountered for a table EMP to a peer sitting beside you who has already having the table of that name (EMP), then what is the result?
17. Display the order number and average item cost for each order.
How to get last row id?
how do u know the total no of rows in a table?
difference between procedures and function?
What is Data Dictionary Cache in Oracle?
Does oracle database need java?
What is a deadlock in SQL? How can you prevent it?
Which is faster join or subquery in oracle?
What is Parallel Server ?
Oracle General 
