create table T(mid int,num int)
go
insert into T select 1,5
insert into T select 1,3
insert into T select 1,5
insert into T select 1,3
insert into T select 2,9
go
SELECT mid,power(10,SUM(log10(num)))
FROM T
GROUP BY mid
go
drop table T