MySQL 获取一组具有不同值的数据 [英] MySQL get set of data with distinct values

问题描述

我有一个简单的问题；我认为会有一个简单的解决方案.想象一个像这样的表:

I have a simple problem; one which I thought would have a simple solution. Imagine a Table like this:

Name           Timestamp              Data
Bob            2011-01-01 01:00:00    Hi
Alice          2011-02-02 02:00:00    Hello
Alice          2011-03-03 03:00:00    Hello
Bob            2011-04-04 04:00:00    Bye
Charlie        2011-05-05 05:00:00    Cheese
Charlie        2011-06-06 06:00:00    Toast

我想要的只是能够运行一个查询，显示每个名称的最新条目.因此，对于上表，我想要这样的输出:

All I want is to be able to run a query that shows the most recent entry for each Name. So with the above table, I would like an output like this:

Name           Timestamp              Data
Bob            2011-04-04 04:00:00    Bye
Alice          2011-03-03 03:00:00    Hello
Charlie        2011-06-06 06:00:00    Toast

按数据排序.我无法弄清楚如何做到这一点.我虽然我可以这样做:

Ordered by Data. I can't figure out how to do this. I though I could just do:

SELECT DISTINCT(Name), timestamp, Data FROM Table ORDER BY Data

但这行不通.非常感激任何的帮助，干杯.

But this doesn't work. Any help would be most appreciated, Cheers.

推荐答案

使用此查询获取最后一个唯一值，

Use this query to get last unique values,

SELECT * FROM (select * from `table` order by date DESC) t group by name

这篇关于MySQL 获取一组具有不同值的数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！