PostgreSQL_CE
PGCES-02 · Question #79
PGCES-02 Question #79: Real Exam Question with Answer & Explanation
Sign in or unlock PGCES-02 to reveal the answer and full explanation for question #79. The question stem and answer options stay visible for context.
Question
The table "score" is defined as follows: gid | score -----+------- 1 | 70 1 | 60 2 | 100 3 | 80 3 | 50 The following query was executed. Select the number of rows in the result. SELECT gid, max(score) FROM score GROUP BY gid HAVING max(score) > 60;
Options
- A1 row
- B2 rows
- C3 rows
- D4 rows
- E5 rows
Unlock PGCES-02 to see the answer
You've previewed enough free PGCES-02 questions. Unlock PGCES-02 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.