PostgreSQL_CE
PGCES-02 · Question #90
The "sample" table consists of the following data: SELECT * FROM sample WHERE v ~ 'ab'; 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 * FROM sample WHERE v ~ 'ab'; 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
(55 responses)- A2% (1)
- B7% (4)
- C84% (46)
- D2% (1)
- E5% (3)
Community Discussion
No community discussion yet for this question.