7,713
社区成员
发帖
与我相关
我的任务
分享
select a, b, min(c) as c, max(c) as d
into 合并表table
from 表table
group by a,b
--取最小和最大
select t.a, t.b, min(t.c) as c, max(t.c) as d
from 表名 as t
group by t.a,t.b
--取第一个和最后一个
select t.a, t.b, first(t.c) as c, last(t.c) as d
from 表名 as t
group by t.a,t.b