3 ms·
something like select * from employees qualify row_number() over ( partition by role order by join_date ) = 1 although I don't
by _dain_ 3y ago
something like
select *
from employees
qualify row_number() over (
partition by role
order by join_date
) = 1
although I don't disagree with you. and `qualify` isn't standard SQL iirc
- pie_flavor 3y agoRight, if you don't have QUALIFY you need a nested SELECT with named outputs within a WITH. (The example is taken from the website.)