怎么用SQL语句实现？

Question

我有一个表，里面的数据是这样的：id                date
                             1                20010101
                             1                20020101
                             1                20030101
                             2                20010101
                             2                20030201
                             3                20040201
                             3                20050201
                             4                20050101
                             4                20020101
我想用一条SQL语句把不同id所对应的date的最大值选出来，我想要的结果是这样的：id               date
                                                                   1                20030101
                                                                   2                20030101
                                                                   3                20050101
                                                                   4                20050101                         

Answer 1

select id,max(date) from table group by id

Answer 2

select id,max(date) from test1 group by id

Answer 3

LS給的不是LZ想要的:月和日都是0101
id      date 
1       20030101 
2       20030101 
3       20050101
4       20050101 try:
select id1,to_char(max(date1),'yyyy')||'0101' as maxdate
from aaatb
group by id1------------------------
    ID1 MAXDATE
1 1 20030101
2 2 20030101
3 3 20050101
4 4 20050101