blob: 8e25901f8ff2a737ae3a9a0d399478d53d4a8e13 [file] [log] [blame]
select
count(*) over pos_win `count`,
sum(salary) over pos_win `sum`,
row_number() over pos_win `row_number`,
rank() over pos_win `rank`,
dense_rank() over pos_win `dense_rank`,
cume_dist() over pos_win `cume_dist`,
percent_rank() over pos_win `percent_rank`
from dfs.`window/%s`
window pos_win as %s