Re:The software industry's greatest sin: hiring
by __s on Thursday April 09, 2020 @11:41PM
(#22829794)
SQL isn't the most portable language. Postgres has special behavior for aggregates/having without group by which essentially creates an implicit group by, other engines will raise an error (SQL Server iirc)
Clearly not something to nitpick over in an interview
He's technically right though. For instance in postgres, you don't need to have a GROUP BY clause when using HAVING https://www.postgresql.org/docs/current/sql-select.html#SQL-...