Мой запрос: < /p>
SELECT cat_name AS category_name, SUM( cat ) AS catgory_count, SUM( total ) AS category_sum, (
SUM( total ) *100 / '10942263'
) AS Percentage
FROM (
SELECT a.category_name AS cat_name, COUNT( a.category_name ) AS cat, SUM( b.position ) AS total
FROM erom.category a, erom_kmch.nsdl b
WHERE a.bene_type_nsdl = b.bene_type
AND a.bene_stype_nsdl = b.bene_stype
AND b.date = '2016-07-22'
GROUP BY cat_name
UNION ALL SELECT a.category_name AS cat_name, COUNT( a.category_name ) AS cat, SUM( b.shares ) AS total
FROM erom.category a, erom_kmch.cdsl b
WHERE a.type_cdsl = b.type
AND a.bo_substat_cdsl = b.bo_substat
AND b.date = '2016-07-22'
GROUP BY cat_name
UNION ALL SELECT a.category_name AS cat_name, COUNT( a.category_name ) AS cat, SUM( b.shares ) AS total
FROM erom.category a, erom_kmch.member_member_master b
WHERE a.substatus_phy = b.substatus
AND b.date = '2016-07-22'
AND shares > '0'
GROUP BY cat_name
)c
GROUP BY cat_name
-----------------------
< /code>
И я получаю выход как < /p>
----------------
category_name catgory_count category_sum Percentage
Bank-Nationalised 1 100 0.0009138877396750563
Clearing Member 13 2459 0.022472499518609634
Individual- Director 1 100 0.0009138877396750563
Individual- Directors Relative 7 139969 1.2791595303457794
Individual- Promoters 1 30000 0.2741663219025169
Individual-Minor 1 1 0.000009138877396750563
----------------------
< /code>
Но нуждается в выводе как Count (индивидуальный директор, отдельные директора, относительные, индивидуальные промоутеры) как одноиндивидуальные и график 9 < /p>
Мне нужен вывод, например, < /p>
category_name catgory_count category_sum
One-Individual 9 170069
< /code>
Мне нужен вывод после получения первого вывода, если кто -то знает, помогите мне < /p>
Подробнее здесь: https://stackoverflow.com/questions/395 ... ysql-query
