select MobileType, COUNT(*) as CNT
, Convert(DECIMAL(5, 0), COUNT(*)* 100.0/sum(count(*)) over () ) as Rate
from BannerClick
group by MobileType

arrow
arrow
    文章標籤
    MS SQL Percent 百分比 decimal over count sum
    全站熱搜

    bagwant 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄