本文介绍了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)
更多推荐
SQL查询组和最大
发布评论