一个sql分组的问题 ，急急急急急急急急急急急急急急急

Question

有如下数据
id date value1 value2
1 2015-01-01 100 200
1 2015-01-02 210 90
2 2015-01-02 110 220
2 2015-01-03 120 140
2 2015-01-04 50 50
3 2015-01-01 100 100
按照id分组，取日期最大的那条记录，并且获得value1 value2
结果

id date value1 value2
1 2015-01-02 210 90
2 2015-01-04 50 50
3 2015-01-01 100 100

请问怎么做

Answer 1

 select id, max([date]) as [date], (select max(value1 from table where [date] = max[date]) as value1, (select max(value2 from table where [date] = max[date]) as value2 from table