关于分组查询的问题。
有一表（aws）
字段 id time value1 value2 value3
值 1 12 1 1 1
1 13 2 2 2
1 5 3 3 3
2 14 1 1 1
2 23 2 2 2
3 16 1 1 1
3 02 2 2 2
3 21 3 3 3
我要从该表中分组查询出max（time）的各id的其他所有值
即 id time value1 value2 value3
1 13 2 2 2
2 23 2 2 2
3 21 3 3 3
请问SQL语言怎么写呢？
[解决办法]
Select
A.*
From
aws A
Inner Join
(Select id, Max([time]) As [time] From aws Group By id) B
On A.id = B.id And A.[time] = B.[time]
[解决办法]
select a.* from tb a,
(select id , max(time) as time from tb group by id) b
where a.id = b.id and a.time = b.time
