Câu 45: DA0-002: CompTIA Data+
A data analyst receives a request for the current employee head count and runs the following SQL statement:SELECT COUNT(EMPLOYEE_ID)FROM JOBS -The returned head count is higher than expected because employees can have multiple jobs. Which of the following should return an accurate employee head count?
Nội dung câu hỏi
A data analyst receives a request for the current employee head count and runs the following SQL statement:SELECT COUNT(EMPLOYEE_ID)FROM JOBS -The returned head count is higher than expected because employees can have multiple jobs. Which of the following should return an accurate employee head count?
Các lựa chọn
Đáp án được giữ gọn theo nhãn A, B, C, D trong phần bình chọn tương tác.
- A. SELECT JOB_TYPE, COUNT DISTINCT(EMPLOYEE_ID)FROM JOBS
- B. SELECT DISTINCT COUNT(EMPLOYEE_ID)FROM JOBS
- C. SELECT JOB_TYPE, COUNT(DISTINCT EMPLOYEE_ID)FROM JOBS
- D. SELECT COUNT(DISTINCT EMPLOYEE_ID)FROM JOBS — đáp án hiện tại
Cộng đồng
0 bình luận công khai. Tên thành viên được ẩn một phần.
Chưa có bình luận. Mở giao diện tương tác để bắt đầu thảo luận.