News for hackers. Stuff that matters.
Re:The software industry's greatest sin: hiring by gruez on Thursday April 09, 2020 @11:16PM (#22829658)
> He explained you don't need a group by in a having statement and that I needed to go back and study sql. I sat there awkwardly [I have been writing sql since I was 14 - I was 25].

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-...

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

Re:The software industry's greatest sin: hiring by war1025 on Thursday April 09, 2020 @11:42PM (#22829796)
"Technically correct", the most irritating form of "correct"
Re:The software industry's greatest sin: hiring by Infernal on Friday April 10, 2020 @01:37AM (#22830292)
Also, technically the only form of correct.