3 ms·

select this, count(*) from that group by 1

• dominotw 4y ago
  I actually find this less readable. i have to go back and scan the select to see what column this index corresponds to. Totally breaks the flow of reading.
• eatonphil 4y ago
  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.
• zasdffaa 4y ago
  Please never allow this into production. I believe it is deprecated, it certainly is fragile in general.