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
- 5062 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 are oracle functions?
Calculate difference between 2 date / times in oracle sql?
Why do we need oracle client?
How can I introduce multiple conditions in like operator?
Explain the use of grant option in imp command.
What is a relational database management system?
What is the relationship among database, tablespace and data file?
What are the attributes of cursor?
How to create a new view in oracle?
How to use subqueries with the in operator using oracle?
How do I learn what codesets are available in oracle?
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.
How to connect asp pages to oracle servers?
What is the difference between pre-select and pre-query?
How to check the server version in oracle?
