sql 查询问题

Question

SELECT MIN(ID)ID,NAME,SUM(NUM)NUM FROM TB GROUP BY NAME

Answer 1

select 
  min(id) as id,
  name,
  sum(num) as num
from 
  tb
group by
  name

Answer 2

SELECT MIN(ID)ID,NAME,SUM(NUM)NUM FROM TB GROUP BY NAME

Answer 3

create funcation test(@name)
return int
as
select sum(num)
from tb
where name=@num
select id,name,test(name)
from tb A
where not exist (select 1 from tb B where A.name=B.name and A.id>B.id)

Answer 4

SELECT MIN(ID)ID,NAME,SUM(NUM)NUM FROM TB GROUP BY NAME