خرید بک لینک

Vote count: 0

In excel and other similar software you can use total to get the percentage. Can anyone tell what is the most efficient way to replicate total function.

I have used nested query but I am not getting right result

select retpre04recency,
count(*) as CustomerCount,
(select count(*) from extractsummary) as Total,
round(count(*)/(select count(*) from extractsummary),2) as CustomerCount
    from extractsummary
    group by retpre04recency
    order by retpre04recency asc
    ;

My result in percentage column is zero. can anyone help?

enter image description here

asked 3 mins ago

برچسب: نویسنده: استخدام کار تاريخ: دوشنبه 27 ارديبهشت 1395 ساعت: 2:44

صفحه بندی