Interested to Buy Any Domain ? << Click Here >> for more details...
Which Department has MOST NUMBER of employees?
- 8 Answers
- 51057 Views
- IBM, LeadSquared, Mastek, I also Faced
- E-Mail Answers
Answer Posted / aswini
select dept_id from emp group by dept_id having count(*)=(Select max(count(*)) From Emp group by dept_id)
| Is This Answer Correct ? | 2 Yes | 14 No |
Post New Answer View All Answers
What is the difference between post-database commit and post-form commit?
What privilege is needed for a user to insert rows to tables in another schema?
I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.
How to assign a table row to a record variable?
What is partitioned table in Oracle?
Explain parameter file in oracle.
How to grant create session privilege to a user in oracle?
What is an Oracle Instance?
What is the usage of analyze command in oracle?
Explain coalesce function?
What is a table index?
What is a synonym? What are its various types?
How to assign data of the deleted row to variables?
Define oracle database
How to use an explicit cursor without open statements?
