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
- 4844 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How to store only time; not date and time?
How to define an external table with a text file?
why dont we assign not null constraint as table level constraint.
How to retrieve values from data fields in record variables?
Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?
What are the different editions of oracle?
How to convert numbers to characters in oracle?
Calculate difference between 2 date / times in oracle sql?
src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));
Whether any commands are used for months calculation? If so, what are they?
Can you tell me how to add new column in existing views?how?How is possible?
What is a parameter file in oracle?
What is tns name?
What are the oracle differences between nvl and coalesce
Can we store pictures in the database and if so, how it can be done?
