MYSQL怎么实现oracle的RANK功能

[sxq129601]

oracle语句为：
select t.*,row_number()over(partition by id,id2 order by id,id2) rn from t

网上的案例都只有一个列作为分组，如果需要2个列分组的怎么写？
例如：
SELECT
IF(@dept = e.deptNo,@rank := @rank +1,@rank := 1) AS rank,
@dept := e.deptNo,
e.*
FROM
(SELECT
@deptno := NULL,@rank := 0) r,
employee e

主要我想取得rank的值

[stelf]

升级数据库到mysql8.0吧，哈哈哈。 select if(@uid = t.user_id and @cid = t.city_id, @rank := @rank + 1, @rank := 1) as rank, t.*, @uid := t.user_id, @cid := t.city_id from (select @uid := null, @cid := null, @rank := 0) r, (select user_id, city_id, city_name, id from t_user_city order by user_id, city_id, id) t;