postgresql 分组排序 partion
在postgresql8.4以后，postgresql添加了window函数。像rank(),row_number(),partion等等，用法和slqserver一模一样。
SELECT *, ROW_NUMBER()
over
(PARTITION By task_id
order by ACTION_TIME ) as rowId
FROM CAMPAIGN_TASK_LOG where CAMPAIGN_TASK_LOG.AFTER_state in('10','15','21','22','23','24')
and ACTION_TYPE='surveysubmit'
refurl:http://my.oschina.net/Kenyon/blog/79543
页:
[1]