Interested to Buy Any Domain ? << Click Here >> for more details...
Which Department has MOST NUMBER of employees?
- 8 Answers
- 50751 Views
- IBM, LeadSquared, Mastek, I also Faced
- E-Mail Answers
Answer Posted / cvsrao
select d.deptname, count(*) as cnt from Employee e inner join
Department d on e.DeptId=d.DeptID
group by DeptName
having count(*) in
(select count(*) from
(select DeptId, count(*) as cnt from Employee group by DeptId)as cnt)
| Is This Answer Correct ? | 1 Yes | 7 No |
Post New Answer View All Answers
What is meant by a deadlock situation?
How to run create database statement?
Describe varray?
How to use "startup" command to start default instance?
How to get a create statement for an existing table?
Can we use bind variables in oracle stored procedure?
What is an oracle?
What is a partition in oracle?
How to establish administrator authentication to the server?
How to create id with auto_increment on oracle?
What are the restrictions on external table columns?
What is SQL access advisor in Oracle?
I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance
Explain oracle instance.
How translate command is different from replace?
