SELECT * from t_user ORDER BY create_time desc
SELECT create_time, COUNT(create_time) as num from t_user GROUP BY create_time ORDER BY num desc
SELECT * from t_user ORDER BY create_time desc
SELECT create_time, COUNT(create_time) as num from t_user GROUP BY create_time ORDER BY num desc
转载于:https://www.cnblogs.com/cs294639693/p/10164420.html