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 |
Explain the relationship among Database, Tablespace and Data file?
What are the uses of Database Trigger ?
1.display list of all users from ur data base.what is the query?
How does Oracle guarantee data integrity of data changes?
Explain the family trees and connection by clause
What privilege is needed for a user to create tables in oracle?
What is bind variable in oracle 11g?
How do I connect to oracle database?
How to turn on or off recycle bin for the instance?
Explain constraining triggers.
State all possible different index configurations a table can possibly have?
What is a table index?