SQL查询组和最大 [英] SQL Query group and max

问题描述

仅作为示例，我将这些数据存储在一个表中:

Just as an example i''ve got this data in a table:

ID    NAME     DATE
1     TEST-1   2012-1-1
2     TEST-1   2012-4-3
3     TEST-2   2012-2-3
4     TEST-2   2012-6-4

我用什么查询来得到结果

what query do i use to get the result

ID    NAME     DATE
2     TEST-1   2012-4-3
4     TEST-2   2012-6-4

我希望它以GROUP BY的名称显示，并显示具有最大ID的ID?
有没有我可以用来执行此操作的查询，我的SQL技能非常基础.

[edit]添加了文本块[/edit]

I want it to GROUP BY name, and show the one with the max ID?
Is there a query i can use to do this, my sql skills are very basic.

[edit]text block added[/edit]

推荐答案

Select * From tablename where ID in(Select Max(ID) From tablename group by name)

这篇关于SQL查询组和最大的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！