PostgreSQL_CE
PGCES-02 · Question #46
The "sample" table consists of the following data: SELECT i FROM sample GROUP BY i HAVING count(*) = 2; How many rows are returned by executing the following SQL statement?
The correct answer is C. 2 rows. See the full explanation below for the reasoning.
Question
The "sample" table consists of the following data:
SELECT i FROM sample GROUP BY i HAVING count(*) = 2; How many rows are returned by executing the following SQL statement?
Options
- A0 rows
- B1 row
- C2 rows
- D3 rows
- E4 rows
How the community answered
(34 responses)- A6% (2)
- B3% (1)
- C74% (25)
- D15% (5)
- E3% (1)
Community Discussion
No community discussion yet for this question.