Interested to Buy Any Domain ? << Click Here >> for more details...
two tables are there
emp(eno,ename,sal,deptno),dept(deptno,dname).how form the
query in deptno,ename,max(sal)
- 2 Answers
- 4964 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
How do I limit the number of oracle database connections generated by weblogic server?
How to select all columns of all rows from a table in oracle?
What is ordinary table in oracle?
Name the various constraints used in oracle?
WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?
Can you tell me how to add new column in existing views?how?How is possible?
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
What is MTTR advisor in Oracle?
What is the disadvantage of User defind function?
What is the difference between view and materialized view in Oracle?
How to connect to a local oracle 10g xe server?
What is user managed backup in Oracle?
Explain an extent?
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
What the is the diff between local index and global index. give some example.
