IBM
C2090-610 · Question #109
C2090-610 Question #109: Real Exam Question with Answer & Explanation
Sign in or unlock C2090-610 to reveal the answer and full explanation for question #109. The question stem and answer options stay visible for context.
Question
A table named SALES contains a record for every sales transaction a company processes. A user wishes to see the number of transactions that are made by each salesman. Which SQL statement will produce the desired results?
Options
- ASELECT name, COUNT(*) AS transactions
- BSELECT name, COUNT(DISTINCT name) AS transactions
- CSELECT name, COUNT(*) AS transactions
- DSELECT DISTINCT name, COUNT(*) AS transactions
Unlock C2090-610 to see the answer
You've previewed enough free C2090-610 questions. Unlock C2090-610 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.