Your browser does not support JavaScript!

Which of the following query is correct which will display the same output as shown below?

  • SELECT COUNT(DISTINCT MANAGER_ID) AS "NO OF MANAGER_ID" FROM EMPLOYEES; Correct
  • SELECT COUNT *(DISTINCT MANAGER_ID) AS "NO OF MANAGER_ID" FROM EMPLOYEES;
  • SELECT COUNT(DISTINCT MANAGER_ID) AS NO OF MANAGER_ID FROM EMPLOYEES;
  • SELECT COUNT(MANAGER_ID) AS "NO OF MANAGER_ID" FROM EMPLOYEES;
Feedbacks
PurpleTortoise - 2 years ago
Upvoted this question
BewilderedCattle - 2 years ago
Downvoted this question
OrthodoxDamselfly - 2 years ago
Upvoted this question
TroubledTiglon - 2 years ago
Downvoted this question
GreenPtarmigan - 2 years ago
Upvoted this question
PreciousBobcat - 2 years ago
Downvoted this question
Similar IT-6202 questions