select '20060522 1702' ,count(mobile_no) from Daily_USER_INTEGRAL where to_char(in_time,'YYYYMMDD HH24mi')='20060522 1702' group by '20060522 1702'
to goldarcher2005: 执行结果不对,如下: '200605221702' COUNT(MOBILE_NO) -------------- ---------------- to xiaoxiao1984(潇潇) :其实小菜的意思,并不为输出而输出那几个字符,想问问,用到了 group by,是否还能返回 值,我用了nvl decode试了,好象没成功.
执行结果不对,如下:
'200605221702' COUNT(MOBILE_NO)
-------------- ----------------
to xiaoxiao1984(潇潇) :其实小菜的意思,并不为输出而输出那几个字符,想问问,用到了 group by,是否还能返回 值,我用了nvl decode试了,好象没成功.