已解决sql分组问题

2019独角兽企业重金招聘Python工程师标准>>>

我想对code这一列做分组统计，请问大神sql语句该怎么写？

这是我写的sql语句

SELECT

 t1.id,

 t1.code,

 t1.[count],

 dbo.dictText (t1.dwmc, 'dwmc') AS dwmc,

 dbo.dictText (t1. LEVEL, 'tar_level0') AS LEVEL,

 dbo.dictText (t1.wd_id, 'wd_detail') AS wd_id,

 dbo.dictText (t1.bd_id, 'bd_detail') AS bd_id,

 dbo.dictText (t1.property, 'tar_property') AS property,

 dbo.dictText (t1.data_from,'tar_datafrom') AS data_from,

t1.create_time,

 t1.repeal_time

FROM

         tar_rentou t1

INNER JOIN activity t2 ON t2.target_code = t1.code

执行后的sql语句如下图

经过不懈的努力终于写出了sql语句

SELECT

         dbo.dictText (dwmc, 'dwmc') AS dwmc,

         code,

         COUNT (1) AS mbcount,

         dbo.dictText (LEVEL, 'tar_level0') AS LEVEL,

         dbo.dictText (wd_id, 'wd_detail') AS wd_id,

         dbo.dictText (bd_id, 'bd_detail') AS bd_id,

         dbo.dictText (property, 'tar_property') AS property,

         dbo.dictText (data_from, 'tar_datafrom') AS data_from,

         create_time,

         repeal_time

FROM

         (

                   SELECT

                            code,

                            dwmc,

                            [level],

                            wd_id,

                            bd_id,

                            property,

                            data_from,

                            create_time,

                            repeal_time

                   FROM

                            tar_rentou

                   INNER JOIN activity t2 ON t2.target_code = tar_rentou.code

         ) _t

GROUP BY

         code,

         dwmc,

         LEVEL,

         wd_id,

         bd_id,

         property,

         data_from,

         create_time,

         repeal_time

执行后的sql语句如下图

很开心功夫不负有心人

转载于:https://my.oschina.net/1024345181/blog/337896