AMA University Answers
Login
Register
AMA OED
Courses
IT
IT-6202
Which of the following query i...
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
Which of the following is the correct example updating the student LASTNAME TO =E2=80=98SANTOS' and...
Which of the following is the correct example updating all student COURSE to =E2=80=98BSIT' from STU...
Which of the following is the correct example of updating the LASTNAME to =E2=80=98REYES' of all stu...
Which of the following is the correct example of updating the COURSE to =E2=80=98N/A' of all student...
Which of the following is the correct example of creating a new table STUDENTS? The column STUDID is...
Which of the following is the correct example of removing a column SALARY from EMPLOYEES table?