3 ms·

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

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 don't get it. Could someone explain how this works?

lgsilver 4y ago
Most SQL dialects accept a positional or a direct reference to the column name. “1” represents the first column created by the select statement, “name”.
- eatonphil 4y ago
  Ah I see. Is that how `count(1)` also works? Or is that different.
  - xapata 4y ago
    Different. SQL's syntax is funky.