22,209
社区成员
发帖
与我相关
我的任务
分享超难的sql 语句 求救
如何实现
select v0,first(v1) as s1,last(v2) as s2,sum(v3) as hj from
表 GROUP BY v0;
access是可以的，但是在sql server 中怎么实现？
select v0,first(v1) as s1,last(v2) as s2,sum(v3) as hj from
表 GROUP BY v0;
access是可以的，但是在sql server 中怎么实现？
...全文
请发表友善的回复…
发表回复
昵称被占用了 2007-06-17
- 打赏
- 举报
select v0,
(select top 1 v1 from 表 where v0=a.v0 order by key) as s1,
(seelct top 1 v2 from 表 where v0=a.v0 order by key desc ) as s2,
sum(v3) as hj
from
表 a GROUP BY v0;
(select top 1 v1 from 表 where v0=a.v0 order by key) as s1,
(seelct top 1 v2 from 表 where v0=a.v0 order by key desc ) as s2,
sum(v3) as hj
from
表 a GROUP BY v0;
