two tables are there
emp(eno,ename,sal,deptno),dept(deptno,dname).how form the
query in deptno,ename,max(sal)
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 concurrency in oracle?
What is the exact use of Collections?
How to rename an existing table?
What are the differences between a sys and system user and what are the extra privileges available to the sys user?
Is truncate autocommit in oracle?
Can we save images in a database and if yes, how?
What is the data type of dual table?
How to put more than 1000 values into an oracle in clause?
What is the relation of a user account and a schema?
What is translate in oracle?
Describe the different type of Integrity Constraints supported by ORACLE ?
what is the difference between no rows returned and null returned?