select * into #tmp from (
select 1 id1 , 2 id2 union all
select 6 id1 , 8 id2 union all
select 3 id1 , 6 id2 union all
select 2 id1 , 5 id2 union all
select 7 id1 , 4 id2 union all
select 8 id1 , 8 id2 union all
select 6 id1 , 3 id2 union all
select 4 id1 , 9 id2 ) a select * from #tmp 用一个最简单的查询 查询出 id1值最大的行中的id2的值,不用连接,不用子查询
select 1 id1 , 2 id2 union all
select 6 id1 , 8 id2 union all
select 3 id1 , 6 id2 union all
select 2 id1 , 5 id2 union all
select 7 id1 , 4 id2 union all
select 8 id1 , 8 id2 union all
select 6 id1 , 3 id2 union all
select 4 id1 , 9 id2 ) a select * from #tmp 用一个最简单的查询 查询出 id1值最大的行中的id2的值,不用连接,不用子查询
select top 1 max(id1) as maxid1,id2 from #tmp group by id2
order by maxid1 desc
order by id1 desc