求同一值的最小id.txt

SQL语言常用的一些命令各代码

id fid
1 2
2 2
3 2
4 2
5 3
6 3
7 3
8 3 

我想返回这样：
id fid
1 2
5 3


/*测试数据*/
declare @tab table(id int,fid int)
insert into @tab select 1,2 
union all        select 2,2
union all        select 3,2
union all        select 4,2
union all        select 5,3
union all        select 6,3
union all        select 7,3
union all        select 8,3
select min(id)as id, b.fid from @tab a
inner join (select distinct(fid) from @tab as fid) b
on a.fid=b.fid
group by b.fid