【SQL】排除重复并排序

来源：百度知道 编辑：UC知道 时间：2024/05/25 19:06:42
IP TIME
10.189.190.52 2008-8-1 15:00
10.189.190.52 2008-8-1 11:00
10.189.190.52 2008-8-1 17:00
10.190.23.163 2008-8-1 17:00
10.190.23.163 2008-8-1 16:00
10.190.23.164 2008-8-1 16:00
10.190.23.165 2008-8-1 16:00
10.190.23.166 2008-8-1 16:00
10.190.23.166 2008-8-1 17:00

怎么把重复的IP排除掉，只留TIME最晚的那个

就是达到这个效果

10.189.190.52 2008-8-1 17:00
10.190.23.163 2008-8-1 17:00
10.190.23.164 2008-8-1 16:00
10.190.23.165 2008-8-1 16:00
10.190.23.166 2008-8-1 17:00

这个句子怎么写呢

select ip,max(time) group by ip

select ip,max(time)
from aaa
group by ip

表名：TAB
表结构
ip time
10.189.190.52 2008-8-1 15:00
10.189.190.52 2008-8-1 11:00
10.189.190.52 2008-8-1 17:00
10.190.23.163 2008-8-1 17:00
10.190.23.163 2008-8-1 16:00
10.190.23.164 2008-8-1 16:00
10.190.23.165 2008-8-1 16:00
10.190.23.166 2008-8-1 16:00
10.190.23.166 2008-8-1 17:00

select ip,max(time) from TAB group by ip

附：我用的是oracle