PostgreSQL_CE
PGCES-02 · Question #82
The "sample" table consists of the following data: SELECT DISTINCT ON (data) * FROM sample; How many rows are returned by executing the following SQL statement?
The correct answer is B. 3 rows. See the full explanation below for the reasoning.
Question
The "sample" table consists of the following data:
SELECT DISTINCT ON (data) * FROM sample; How many rows are returned by executing the following SQL statement?
Options
- A2 rows
- B3 rows
- C4 rows D. 5 rows
- D6 rows
How the community answered
(36 responses)- A11% (4)
- B81% (29)
- C3% (1)
- D6% (2)
Community Discussion
No community discussion yet for this question.