方法一,举例:
查询用户表中id=2的用户创建时间的排名:
select count(*) as rank from `user` where create_time <= (select create_time from `user` where id = 2);
yii写法:
$subQuery = self::find()->select("create_time")
->from('user')
->where(['id' => $id]);
$query = self::find()->select('COUNT(*) as rank')
->from('user')
->where(['<=', "create_time", $subQuery]);
return $query ->asArray()->one();
方法二,没用到,用到再说