By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
| id | thename | thedate |
|---|---|---|
| 2 | John | 2021-01-01 |
| 3 | John | 2022-01-01 |
SELECT 2