eatonphil
searching PlanetScale…
- 1.▲
- 2.▲
- 3.▲
- 4.▲
- 5.▲
- 6.▲
72 ms·
- 1441.▲
- 1442.▲
- 1443.▲
- 1444.▲
- 1445.▲
- 1446.▲
- 1447.▲
Tested this out on Postgres and it works: SELECT
name, count(1)
FROM
(VALUES ('Kev',12), ('Meg', 14), ('Kev', 14))
people(name, age)
GROUP BY
1
Produces: [[Kev, 2], [Meg, 1]]. But I d - 1448.▲
- 1449.▲
- 1450.▲
- 1451.▲
- 1452.▲
- 1453.▲
- 1454.▲
- 1455.▲
- 1456.▲
- 1457.▲
- 1458.▲
- 1459.▲
- 1460.▲
- 1461.▲
- 1462.▲
- 1463.▲
- 1464.▲
- 1465.▲
- 1466.▲
- 1467.▲
- 1468.▲
- 1469.▲
- 1470.▲
More ›