4 ms·
You can do that with window functions in Postgres: SELECT MAX(salary) OVER (), first_name, last_name FROM employee;
by unterdenlinden 4y ago
You can do that with window functions in Postgres:
SELECT MAX(salary) OVER (), first_name, last_name FROM employee;
- systems 4y agoexactly, 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