题解 | #输出提交次数大于2次的用户ID且倒序排列#
输出提交次数大于2次的用户ID且倒序排列
https://www.nowcoder.com/practice/e8601af30fc04e08aa87c64fffcff241
select
user_id
from
(
select
user_id,
count(done_time) as ct
from
done_questions_record
group by
user_id
having
ct > 2
) as dqr
order by
user_id desc
竟然是按user_id倒序排列，一开始还以为按提交次数倒序排列
投递深圳市新凯来技术等公司8个岗位