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
- 4961 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
What is a private synonym?
How to get the Installed Oracle Version Information ?
What are group functions in oracle?
How to use "in out" parameter properly?
How to apply filtering criteria at group level in oracle?
Can we create trigger on materialized view in oracle?
What is dynamic proxy?
What are oracle functions?
What are the types of partitions in oracle?
how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?
How to retrieve the count of updated rows?
How to convert a date to char in oracle? Give one example.
How to concatenate two text values in oracle?
How to get a list of all user accounts in the database?
Explain the use of grant option in exp command.
