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
- 5060 Views
- I also Faced
- E-Mail Answers
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 |
Do View contain Data ?
What is the parameter mode that can be passed to a procedure?
What privilege is needed for a user to query tables in another schema?
what is the maximum number of indexes i can create for a table? What happens if i create indexes for all the columns of a table? Will it slow down the speed of retrieval
What is the difference between SQL, DDL, and DML?
7 Answers BeBo Technologies, Wipro,
Hi friends can u send the oracle 9i full version download link?????????????? please reply ?
What is a database schema in oracle?
how to find the n'th highest salary from emp ?
How to get a list of all background sessions in the database?
How do I escape a reserved word in oracle?
What is TNS File
What is the max number of columns in an oracle table?
Oracle General 
