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 |
i have procedure p1.and also i declare the same procedure in a package. whice one is efficient package procedure or procedure?
What SQL query from v$session can you run to show how many sessions are logged in as a particular user account?
Can we convert a date to char in oracle and if so, what would be the syntax?
How to use "while" statements in oracle?
How to change system global area (sga) in oracle?
what happened to the global index when I truncate the data in one of the partition?
What happens in oracle commit?
How to create a new table in your schema?
In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.
What are various constraints used in SQL?
How can we find the size of a database?
What exactly do quotation marks around the table name do?