可以按多行排序吗?
我希望我的用户按last_activity
排序,但同时,我希望有图片的用户出现在没有图片的用户之前
如下所示:
SELECT some_cols
FROM `prefix_users`
WHERE (some conditions)
ORDER BY last_activity, pic_set DESC;
发布于 2011-02-02 23:14:51
SELECT some_cols
FROM prefix_users
WHERE (some conditions)
ORDER BY pic_set DESC, last_activity;
发布于 2011-02-02 23:15:44
先按图片排序,然后按活动排序:
SELECT some_cols
FROM `prefix_users`
WHERE (some conditions)
ORDER BY pic_set, last_activity DESC;
发布于 2017-08-28 18:31:23
SELECT id, user_id, video_name
FROM sa_created_videos
ORDER BY LENGTH(id) ASC, LENGTH(user_id) DESC
https://stackoverflow.com/questions/4876100
复制相似问题