这个SQL语句如何写？

[oldsky]

A# B#
1 1
1 2
1 3
2 1
2 2
2 4
查出A#=2且在A#该组中B#最大的记录

[pengdali]

select top 1 * from 表 where a#=2 order by b# desc

[dwhhh]

select * from table where b#=(select max(b#) from table where a#=2) and a#=2

[海盗2019]

select * from tb_nm t, (select max(B#) b from tb_nm where A#=2) m where t.A#=2 and t.#= m.b;

[zjcxc]

select * from 表
where [a#]=2 and [b#]=(select max([b#]) from 表 where a#=2)

[zarge]

select A#, max(B#) from 表 where A# = 2