4 ms·
DISTINCT ON if I recall correctly is a Postgres-specific extension, and is rather like a shortcut to an OVER WINDOW query selecting where RANK() = 1. And I lov
by johncalvinyoung 10y ago
DISTINCT ON if I recall correctly is a Postgres-specific extension, and is rather like a shortcut to an OVER WINDOW query selecting where RANK() = 1.
And I love it, but I wouldn't be expecting it to show up in MSSQL.