java - JPA 的 Mysql 中 ABS() 的替代方案

Question

我有一个像这样的表:-

+----+-------+
| ID | Score |
+----+-------+
| 3  | -10   |
| 2  | -11   |
| 4  | -9    |
| 5  | 1     |
| 1  | 12    |
+----+-------+

我期待输出

+----+-------+
| ID | Score |
+----+-------+
| 1  | 12    |
| 2  | -11   |
| 3  | -10   |
| 4  | -9    |
| 5  | 1     |
+----+-------+

虽然我有疑问

SELECT * 
  FROM Table 
ORDER BY 
       ABS(score) DESC;

我想要 JPQL/JPA 的替代品。

Answer 1

Query query=em.createQuery("SELECT p FROM Product p WHERE ABS(p.price)<50.0");

来自 source