two tables are there
emp(eno,ename,sal,deptno),dept(deptno,dname).how form the
query in deptno,ename,max(sal)
- 2 Answers
- 4280 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 an oracle function?
nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls
i have procedure p1.and also i declare the same procedure in a package. whice one is efficient package procedure or procedure?
master table and child table performances and comparisons in Oracle ?
How to check database size in Oracle?
How to check the oracle tns settings?
How can you Enforce Referential Integrity in snapshots ?
How to write an inner join with the where clause in oracle?
Describe varray?
what are the disadvantages of hierarchial database over RDBMS?
how to use sequence and what use of sequence cache
How can we find the size of a database?
Oracle General 
