Given two tables EMPLOYEE

February 22, 2020 10:37 am

Choose Your Answer:

ATotal number of employees in each department D1 and D2?

BTotal number of employees of department D1 and D2 if their total is >5

CDisplay total number of employees in both departments D1 and D2

DThe output of the query must have atleast two rows

Eduncle Best Answer
Only option 2 is satisfying the constraints count(*) > 5.

Likes(0) Reply(0)

Head Office :

MPA 44, 2nd floor, Rangbari main Road Mahaveer Nagar II, Kota (Raj.) - 324005

Branch Office (Jaipur):

Shyam Tower, Plot No. F2, 6th Floor Amrapali Circle,
Vaishali Nagar, Jaipur, Rajasthan 302021

Mail: info@eduncle.com