blocks|key|1964068|text|你的意思是？|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1964069|SELECT+priority,+likes+
FROM+table+
WHERE+priority+>+1+AND+priority+<+100++
ORDER+BY+priority,+likes+DESC;|code-block|syntax|javascript|1964070|啊，刚刚看了你的更新，试试这个|1964071|SELECT+priority,+likes+
FROM+table+
ORDER+BY+IF(priority+>+1+AND+priority+<+100,+priority,+likes+DESC)|1964072|或者像我这样的案例|1964073|SELECT+priority,+likes+
FROM+table
ORDER+BY+
++++CASE+WHEN+priority+>+1+AND+priority+<+100+
+++++++++THEN+priority+
+++++++++ELSE+likes+
END+ASC|1964074|注意:语法可能有点差，在这台速度很慢的pc上没有打开我的sql|1964075|entityMap^0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|U|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|V|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|W|8|@]|9|@]|A|$]]|$1|M|3|N|5|D|7|X|8|@]|9|@]|A|$E|F]]|$1|O|3|P|5|6|7|Y|8|@]|9|@]|A|$]]|$1|Q|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|R|$]]

do you mean?

<pre><code>SELECT priority, likes 
FROM table 
WHERE priority &gt; 1 AND priority &lt; 100 
ORDER BY priority, likes DESC;
</code></pre>

ah just looked at your update, try this

<pre><code>SELECT priority, likes 
FROM table 
ORDER BY IF(priority &gt; 1 AND priority &lt; 100, priority, likes DESC)
</code></pre>

or a case like i would use

<pre><code>SELECT priority, likes 
FROM table
ORDER BY 
 CASE WHEN priority &gt; 1 AND priority &lt; 100 
 THEN priority 
 ELSE likes 
END ASC
</code></pre>

Note: syntax might be a tad off, not got my sql open on this slow pc

blocks|key|1584248|text|你能试试这个吗？|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1584249|SELECT+priority,+likes
FROM+table
ORDER+BY+IF+(priority+>+1+AND+priority+<+100,+priority,+0+-+likes);|code-block|syntax|javascript|1584250|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

could you try this?

<pre><code>SELECT priority, likes
FROM table
ORDER BY IF (priority &gt; 1 AND priority &lt; 100, priority, 0 - likes);
</code></pre>

blocks|key|1579000|text|尝尝这个|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1579001|SELECT+priority,+likes+FROM+table+
ORDER+BY+IF(priority+>+1+AND+priority+<+100,+priority,+likes+DESC)|code-block|syntax|javascript|1579002|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Try this 

<pre><code>SELECT priority, likes FROM table 
ORDER BY IF(priority &gt; 1 AND priority &lt; 100, priority, likes DESC)
</code></pre>

blocks|key|1964093|text|请尝试以下操作|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1964094|ORDER+BY+CASE+WHEN+priority+>+1+AND+priority+<+100+THEN+priority+ELSE+likes+END+DESC|code-block|syntax|javascript|1964095|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Try the following

<pre><code>ORDER BY CASE WHEN priority &gt; 1 AND priority &lt; 100 THEN priority ELSE likes END DESC
</code></pre>

blocks|key|1579028|text|您不能根据条件以不同方式排序。"priority“字段是针对每个记录的，因此基于字段值进行排序是没有意义的。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1579029|可能有一个SQL条件，然后使用适当的顺序执行1个SELECT语句，否则执行不同的SQL语句|1579030|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

You cannot sort differently based on a condition. The field "priority" is per record and thus it doesn't make sense to ORDER BY based on a fields value.

Perhaps have a SQL condition and then 1 SELECT with the appropriate ordering, else do a different SQL statement

blocks|key|4281077|text|好的，你是对的，它不能基于条件而不同地排序。我解决这个问题的方法是设置一个参数like/priority作为prio，并按DESC排序|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4281078|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

ok you are right, it can not be sort differently based on a condition. I solve this problem by making a parameter likes/priority as prio and order by DESC

I have a query like this:

<pre><code> SELECT priority, likes FROM table ORDER BY priority, likes DESC;
</code></pre>

The priority and likes are integer polls. I would like to add 'IF' clause that

<pre><code> IF (priority &gt; 1 AND priority &lt; 100)
 {
 ORDER BY priority;
 }
 ELSE
 {
 ORDER BY likes DESC;
 }
</code></pre>

I don't know how to ask about it. 
Thank you in advance

sql SELECT IF AND ORDER BY

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我有一个类似这样的查询： SELECT priority, likes FROM table ORDER BY priority, likes DESC;优先级和点赞是整数投票。我想加上'IF‘从句， IF (priority > 1 AND priority < 100) { ORDER BY pr...

问sql SELECT IF和ORDER BY
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问sql SELECT IF和ORDER BYEN