如何按月计算行数(How to count rows month wise)
有了这个查询,我可以数数
Created By ProductGroup Count HNSHAK MOBILE COMPUTING 13 HNSHAK STORAGE 2查询:
SELECT `Created By`, ProductGroup, COUNT(*) `Count` FROM tablename GROUP BY `Created By`, ProductGroup;现在我想像MARCH / APRIL或04-2013 / 03-2013一样聪明地计算,如果有可能我有一个数据库,其中超过15000个条目,我想显示每个用户计数月份...
我想要像这样的输出
Created By ProductGroup Count MONTH HNSHAK MOBILE COMPUTING 1 MARCH HNSHAK STORAGE 2 MARCH Created By ProductGroup Count MONTH HNSHAK MOBILE COMPUTING 2 APRIL HNSHAK STORAGE 1 APRIL Created By ProductGroup Count MONTH HNSHAK MOBILE COMPUTING 1 FEBRUARY表:
Productgroup Created By Initial Intl Created STORAGE HNSHAK 13.02.2013 SMART+MOBIL+FIX PH. KFKAIS 19.03.2013 SMART+MOBIL+FIX PH. KFKAIS 20.03.2013 SMART+MOBIL+FIX PH. KFKAIS 19.03.2013 SCANNERS MDSALA 20.02.2013 STORAGE HNSHAK 07.03.2013 STORAGE HNSHAK 13.03.2013 MOBILE COMPUTING HNSHAK 01.03.2013 MOBILE COMPUTING HNSHAK 01.04.2013 MOBILE COMPUTING HNSHAK 01.04.2013 PTV/FLAT WSAHMA 12.03.2013 PTV/FLAT WSAHMA 09.03.2013 STORAGE HNSHAK 13.03.2013With this query i can count
Created By ProductGroup Count HNSHAK MOBILE COMPUTING 13 HNSHAK STORAGE 2Query:
SELECT `Created By`, ProductGroup, COUNT(*) `Count` FROM tablename GROUP BY `Created By`, ProductGroup;now i want to count same month wise like MARCH/APRIL or 04-2013/03-2013 kindly help if it is possible i have a database in which more than 15000 entries i want to show each user count month wise...
i want output like this
Created By ProductGroup Count MONTH HNSHAK MOBILE COMPUTING 1 MARCH HNSHAK STORAGE 2 MARCH Created By ProductGroup Count MONTH HNSHAK MOBILE COMPUTING 2 APRIL HNSHAK STORAGE 1 APRIL Created By ProductGroup Count MONTH HNSHAK MOBILE COMPUTING 1 FEBRUARYtable:
Productgroup Created By Initial Intl Created STORAGE HNSHAK 13.02.2013 SMART+MOBIL+FIX PH. KFKAIS 19.03.2013 SMART+MOBIL+FIX PH. KFKAIS 20.03.2013 SMART+MOBIL+FIX PH. KFKAIS 19.03.2013 SCANNERS MDSALA 20.02.2013 STORAGE HNSHAK 07.03.2013 STORAGE HNSHAK 13.03.2013 MOBILE COMPUTING HNSHAK 01.03.2013 MOBILE COMPUTING HNSHAK 01.04.2013 MOBILE COMPUTING HNSHAK 01.04.2013 PTV/FLAT WSAHMA 12.03.2013 PTV/FLAT WSAHMA 09.03.2013 STORAGE HNSHAK 13.03.2013最满意答案
MONTHNAME
select [created by], ProductGroup, Count(Productgroup), MonthName([Initial Intl Created]) from tablename group by [created by],ProductGroup,MonthName([Initial Intl Created])MonthName
select [created by], ProductGroup, Count(Productgroup), MonthName([Initial Intl Created]) from tablename group by [created by],ProductGroup,MonthName([Initial Intl Created])更多推荐
发布评论