如何在子查询PHP MYSQL中按desc排序 [英] How do I sort by desc in a subquery PHP MYSQL

问题描述

我想得到每个User_ID的最后一个（最高）ID，我的代码工作正常，但我也想通过降序来订购



ID User_ID

1 150

2 150

3 151

4 151

Hi, I want to get the last(highest) ID of every User_ID, my code works fine but I also want to order it by descending

ID User_ID
1 150
2 150
3 151
4 151

$result = $this->link->query("SELECT * FROM tickets WHERE ID IN (SELECT MAX(ID) FROM tickets WHERE Type=0 GROUP BY User_ID)");

热门查询给了我：

ID User_ID

2 150

4 151



这就是我想要的：



ID User_ID

4 151

2 150





当我添加ORDER BY ID DESC时，它应该是例如，给我3,2,1，但它默认给我1,2,3。

top query gives me:
ID User_ID
2 150
4 151

and here is what I want:

ID User_ID
4 151
2 150


When I add ORDER BY ID DESC, it should give me 3,2,1 for example, but it gives me 1,2,3 by default.

$result = $this->link->query("SELECT * FROM tickets WHERE ID IN (SELECT MAX(ID) FROM tickets WHERE Type=0 GROUP BY User_ID ORDER BY ID DESC)");

如果你帮助我，我会很高兴：DI在网上搜索大约10个小时我找不到任何解决方案。



谢谢。

I'd be very happy if you help me :D I was searching the internet about 10 hours and I couldn't find any solution.

Thanks.

推荐答案

结果 =

result =

this-> link-> query（ SELECT * FROM tickets WHERE ID IN（SELECT MAX（ID）FROM ticket WHERE Type = 0 GROUP BY User_ID））;

this->link->query("SELECT * FROM tickets WHERE ID IN (SELECT MAX(ID) FROM tickets WHERE Type=0 GROUP BY User_ID)");

top查询给了我：

ID User_ID

2 150

4 151



这就是我想要的：



ID User_ID

4 151

2 150





当我添加ORDER BY ID DESC时，它应该给我3,2,1例如，但它给了我1,2， 3默认情况下。

top query gives me:
ID User_ID
2 150
4 151

and here is what I want:

ID User_ID
4 151
2 150


When I add ORDER BY ID DESC, it should give me 3,2,1 for example, but it gives me 1,2,3 by default.

结果 =

result =

这篇关于如何在子查询PHP MYSQL中按desc排序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！