假设您想要获得的第二行是[2 2 2.5],这就是您要查找的内容:
select a.col1, a.colm, m.col3
from
(
select col1, min(col2) as colm
from test
group by col1
) as a
inner join test m on a.col1 = m.col1 and a.colm = m.col2
MS Access SQL:汇总最小值,但检索其他字段
假设您想要获得的第二行是[2 2 2.5],这就是您要查找的内容:
select a.col1, a.colm, m.col3
from
(
select col1, min(col2) as colm
from test
group by col1
) as a
inner join test m on a.col1 = m.col1 and a.colm = m.col2