Hi,

I am having a problem to display % value of the total count in the query.

The query returns a PIN_COUNT value for specific App_Version, but I would also like to display a % of the total PIN_COUNT. How can I accomplish this?

Thanks


Desired results:

RELAY | APP_VERSION | PIN_COUNT | % |

1 3.6 40 45
1 3.7 20 22.5



Current query:
----------------------------------------------------------------
SELECT /* + index(D device_info_carrier) */

d.relay, nvl(d.app_version,'Unknown') App_Version, count (x.pin) PIN_COUNT

FROM bblg.device_info@prldw d,

(SELECT /* + index(C cdr_sum_dte) */
DISTINCT c.pin, c.rownum
FROM bblg.cdr_summary@prldw c
WHERE c.dte between to_date('03-Dec-2003') and to_date('04-Dec-2003')
) x

WHERE d.pin = x.pin
AND d.carrier = 'NexTel'
GROUP BY d.carrier, d.relay, App_Version
----------------------------------------------------------------