Answer Posted / shibashis

Select d.deptname,count(*) as cnt
from employee e inner join dept d
On e.deptid=d.deptid
group by d.deptname
having cnt in (
select max(cnt) from
(SELECT deptid ,count(*) as cnt FROM employee GROUP BY deptid )
)
order by d.deptname
;

What is an oracle data file?

1105

---

What is a cognitive schema?

973

---

Explain a synonym?

1034

---

What privilege is needed for a user to insert rows to tables in another schema?

1015

---

Can we convert a date to char in oracle and if so, what would be the syntax?

1017

---

How to write date and time literals in oracle?

1002

---

How do I know if oracle is installed on windows?

931

---

What is a subquery?

1125

---

What is a procedure in oracle?

1200

---

What are the benefits of ordbms?

1088

---

How do I start tns listener?

1048

---

What are the various types of snapshots ?

1030

---

What are temporal data types in oracle?

1128

---

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1884

---

What is the difference between hot backup and cold backup in oracle?

1014

---