mysql 实现 row_number() over(pattition by a order by b )
摘要：
SELECT prod_province,prod_cnode,prod_balance,rank FROM ( SELECT b.prod_province,b.prod_cnode,b.prod_balance,@rownum:=@rownum+1 , IF(@pdept=b.prod_prov 阅读全文
posted @ 2016-12-02 18:24 习惯简单 阅读(2699) 评论(0) 推荐(0) 编辑
