Re: Partition by Clause not working

[Peter Brawley]

Sorry, private work ain't free, IAC I neglected to say that with multiple Select expressions you should use the window clause ...

select 
  row_number() over w as rownum,
  fullname,email,completionstate
from n
window w as (
  partition by email, fullname 
  order by completionstate
);