win_func_percent_rank.sql 168 B

12345678
  1. select
  2. r,x,
  3. percent_rank() over w,
  4. percent_rank(x) over w,
  5. from (select * from (values (1,null),(2,3),(3,4),(4,4)) as a(r,x)) as z
  6. window w as (order by r)
  7. order by r