Saved Bookmarks
| 1. |
Choose the correct query to display the number of employees present in Delhi and Mumbai.i. Select SUM(no of employee), Location from STORE group by location HAVING location in (“Delhi”,”Mumbai”); ii. Select SUM(no of employee), Location from STORE group by location WHERE location in (“Delhi”,”Mumbai”); iii. Select SUM(no of employee), Location from STORE group by location HAVING location =“Delhi” and location=”Mumbai”; iv. Select SUM(no of employee), Location from STORE group by location WHERE location =“Delhi” or location=”Mumbai”;Choose the correct option: a. Both i and ii b. Both ii and iii c. Both iii and iv d. Both i and iii |
|
Answer» Correct option: d. Both i and iii |
|