1.9、ntile(分组数量)—让所有记录尽可以的均匀分布 1.9、ntile(分组数量)—让所有记录尽可以的均匀分布 postgres =# select ntile ( 2 ) over ( partition by begincity order by id ),* from bills ; ntile | ...
1.3、row_number() —返回行号,按amount排序 1.3、row_number() —返回行号,按amount排序 postgres =# select row_number () over ( order by amount ),* from bills ; row_number | id | ...