87A7827C-3364-4B1F-A90D-699CAB6159B9.png
查询ORDER BY|升序ASC (低->高)
SELECT u.user_name ,u.user_weigh FROM tb_user u ORDER BY u.user_weigh ASC;
查询ORDER BY|降序 DESC (高->低)
SELECT u.user_name ,u.user_weigh FROM tb_user u ORDER BY u.user_weigh DESC;
多列排序
SELECT u.user_name, u.user_age, u.user_weigh, u.user_change
FROM tb_user u
ORDER BY u.user_age ASC,u.user_weigh DESC;
模糊 + 升序查询
SELECT u.user_name, u.user_age, u.user_weigh, u.user_weigh *10 as _weight FROM tb_user u
WHERE u.user_name LIKE "%C%"
ORDER BY _weight ASC;
网友评论