two tables are there
emp(eno,ename,sal,deptno),dept(deptno,dname).how form the
query in deptno,ename,max(sal)
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
What are ddl statements in oracle?
What is user managed backup in Oracle?
How to filter out duplications in the returning rows using oracle?
Can we use oracle pl/sql block in core java? if so how? pls get back to me .....
What is the quickest way to fetch the data from a table?
normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi
What are the four Oracle system processes that must always be up and running for the database to be useable?
What is a trigger and what are its types in oracle?
What is the implicit cursor in oracle?
Can we store images in oracle database?
How to pass a cursor variable to a procedure?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
How to convert characters to times in oracle?
What are the differences between lov and list item?