Answer Posted / abhisudipta

select d.dept_name,e.emp_nm,max(e.sal) as salary
from dept d, emp e
where d.dept_no=e.dept_no and e.emp_nm = (select emp_nm from
emp where sal=(select max(sal) from emp where
dept_no=d.dept_no))
group by d.dept_name,e.emp_nm;

How do I find the database name in oracle?

1041

---

What is the difference between substr & instr functions?

1233

---

What is execute immediate in oracle?

1023

---

How do you tell what your machine name is and what is its IP address?

2100

---

What are the logical operations?

1128

---

How to omit columns with default values in insert statement in oracle?

1050

---

How do I uninstall oracle client from windows?

1014

---

How to work with data objects interactively?

991

---

How to rename an index?

1076

---

Name the three major set of files on disk that compose a database in Oracle?

1127

---

What is the purpose of tables, private synonyms and public synonyms in Oracle?

1048

---

Can we commit inside a function in oracle?

968

---

What to do if dba lost the system password?

1176

---

Explain self joins in oracle?

1025

---

What are the numeric comparison operations?

1121

---