无法从mysql中选择最新的而不是相同的数据

I have value like this.

我有这样的价值。

id  website   time
1   aaa.com   11.10
2   bbb.com   11.10
3   ccc.com   11.10
4   aaa.com   11.11
5   bbb.com   11.11
6   ccc.com   11.11

I want to select latest and not same data in table. It should be .

我想在表格中选择最新的而不是相同的数据。它应该是。

4   aaa.com   11.11
5   bbb.com   11.11
6   ccc.com   11.11

I query like this

我这样查询

"SELECT * FROM name GROUP BY website ORDER BY id DESC";

It alway show DESC and ASC.

它总是显示DESC和ASC。

1   aaa.com   11.10
2   bbb.com   11.10
3   ccc.com   11.10

How to select latest value with not same data ?

如何选择不同数据的最新值?

1 个解决方案

#1

Join to a subquery which finds the latest record for each website:

加入子查询,查找每个网站的最新记录:

SELECT t1.*
FROM yourTable t1
INNER JOIN
(
    SELECT website, MAX(time) AS max_time
    FROM yourTable
    GROUP BY website
) t2
    ON t1.website = t2.website AND
       t1.time = t2.max_time;

You are storing your times apparently in some text format. This isn't desirable, and it would be better to store date times instead. If the width of the time is always the same (5 telling from your sample data), then my query should work though.

您显然以某种文本格式存储您的时间。这是不可取的,而且最好存储日期时间。如果时间的宽度总是相同的(从样本数据中得知),那么我的查询应该可行。

1 个解决方案

#1

更多相关文章

随机推荐