求一个SQL语句,ACCESS库

[看那山瞧那水]

比如一个表如下:

A , B //字段

1 , 1
1 , 2
1 , 3
2 , 1
2 , 2
2 , 3
2 , 4
3 , 1
3 , 2
3 , 3

找出最大A及最大B的记录,就是首先满足MAX(A),然后满足MAX(B),
结果是
3,3
而不是
3,4
用一条SQL语句怎么写

我目前是用2次查询实现

[kaikai_kk]

select Max(A) A,Max(B) B From t where A=(Select Max(A) From t)
或
select Max(Y.A) A,Max(B) B From t x,(Select Max(A) A From t) Y where X.A=Y.A

[kaikai_kk]

或
select top 1 A,B From t order by A desc,B desc

[sundayzhao]

select top 1 A,B From t order by A desc,B desc

select a,max(b) as b from t
group by a
order by a desc

[看那山瞧那水]

OK,结了