表格如图所示
我要查询出每一个站号对应的年份的最小年
并且该年对应的最小月份

帮忙给出查询语句
谢谢

min

select a.StationNo,a.Year, b.Month
from (select StationNo, year = min(year) from tblStation group by StationNo ) a
join (select StationNo,year, month = min(month) from tblStation group by StationNo,Year) b
on a.StationNo = b.StationNo and a.Year = b.Year

BTW:楼主你应该发到数据库论坛去