求一个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次查询实现
[解决办法]
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
[解决办法]
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
