SQL查询组和最大

本文介绍了SQL查询组和最大的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

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

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)