two tables are there
emp(eno,ename,sal,deptno),dept(deptno,dname).how form the
query in deptno,ename,max(sal)
- 2 Answers
- 4045 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Explain the use of indexes option in exp command.
What is a data dictionary and how can it be created?
What is object data modeling?
What is oracle thin client?
What is the difference between primary key and unique key and foreign key in oracle?
What is execute immediate in oracle?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
How to bring a tablespace offline?
What is BBED in Oracle?
What is control file used for?
What is merge statement used for?
What is the exact use of Collections?
What is the difference between Delete, Truncate and Drop in Oracle?
Select all the employees who were hired in last 2 years and who works in dept where max managers are working.
What are transaction isolation levels supported by oracle?
