Hacker News Reader

You can do that with window functions in Postgres:

SELECT MAX(salary) OVER (), first_name, last_name FROM employee;

exactly, SQL being a declarative language, you should always prefer explicit over implicit

SQL bugs are very hard to detect, when the query return a result that looks right, and because the language is declarative its easy to do those mistakes

Reply on news.ycombinator.com