SQL查询统计重复项问题

blackzvik 2014-02-19 03:04:14

如上图，我想重复的项只显示一条，并计算重复项Enum，Eprice的和。

...全文

114 7 打赏收藏转发到动态举报

写回复

用AI写文章

7 条回复

切换为时间正序

请发表友善的回复…

发表回复

KeepSayingNo 2014-02-19

打赏
举报


select a.*,b.enum,b.eprice from
(
    select distinct grade,depname,zyname,pubnum,pbname,pbprice,pbdiscount
    from 表
) a
inner join 
(
    select pubnum,sum(enum) enum,sum(eprice) eprice
    from 表
    group by pubnum
) b
on a.pubnum=b.pubnum

KeepSayingNo 2014-02-19

打赏
举报

恭迎品鉴


select a.*,b.enum,b.eprice from
(
    select distinct grade,depname,zyname,pubnum,pbname,pbprice,pbdiscount
    from 表
) a
inner join 
(
    select distinct pubnum,sum(enum) enum,sum(eprice) eprice
    from 表
    group by pubnum
) b
on a.pubnum=b.pubnum

blackzvik 2014-02-19

打赏
举报

引用 1 楼 DBA_Huangzj 的回复:

select grade,depname,zyname,pubnum,pbname,pbprice,pbdiscount,sum(enum)enum,sum(eprice)eprice from 表 group by grade,depname,zyname,pubnum,pbname,pbprice,pbdiscount

引用 2 楼 OrchidCat 的回复:

select grade,depname,zyname,pubnum,pbname,pbprice,pbdiscount,sum(Enum) as enum,sum(Eprice) as eprice
from TB
group by grade,depname,zyname,pubnum,pbname,pbprice,pbdiscount

简单点儿

引用 4 楼 yupeigu 的回复:

试试这个：

select grade,depname,zyname,pubnum,pbname,pbprice,pbdiscount,
       SUM(enum) as enum,
       SUM(eprice) as eprice
from tb
group by grade,depname,zyname,pubnum,pbname,pbprice,pbdiscount

原来是用Group by，谢谢几位了！

LongRui888 2014-02-19

打赏
举报

试试这个：

select grade,depname,zyname,pubnum,pbname,pbprice,pbdiscount,
       SUM(enum) as enum,
       SUM(eprice) as eprice
from tb
group by grade,depname,zyname,pubnum,pbname,pbprice,pbdiscount

發糞塗牆 2014-02-19

打赏
举报

SELECT  grade ,
        depname ,
        zyname ,
        pubnum ,
        pbname ,
        pbprice ,
        pbdiscount ,
        SUM(enum) enum ,
        SUM(eprice) eprice
FROM    表
GROUP BY grade ,
        depname ,
        zyname ,
        pubnum ,
        pbname ,
        pbprice ,
        pbdiscount

Mr_Nice 2014-02-19

打赏
举报

select grade,depname,zyname,pubnum,pbname,pbprice,pbdiscount,sum(Enum) as enum,sum(Eprice) as eprice
from TB
group by grade,depname,zyname,pubnum,pbname,pbprice,pbdiscount

简单点儿

發糞塗牆 2014-02-19

打赏
举报

select grade,depname,zyname,pubnum,pbname,pbprice,pbdiscount,sum(enum)enum,sum(eprice)eprice from 表 group by grade,depname,zyname,pubnum,pbname,pbprice,pbdiscount