Hacker News new | ask | show | jobs
by lgsilver 1373 days 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”.
1 comments

Ah I see. Is that how `count(1)` also works? Or is that different.
Different. SQL's syntax is funky.