Home MySQL查询如何把指定数据行排在前面
Post
Cancel

MySQL查询如何把指定数据行排在前面

如果只是一条数据行,可以这样:

1
SELECT * FROM user ORDER BY user_id <> 7, score DESC;

主要是user_id <> 7 ,会把用户id为7的排在前面。

如果是多条数据行:

1
SELECT * FROM user ORDER BY user_id NOT IN (7, 8, 9), score DESC;
This post is licensed under CC BY 4.0 by the author.

pom文件报错:The POM for com.oracle:ojdbc14:jar:10.2.0.1.0 is missing

MySQL中使用SQL语句从文本文件导入数据