Личный кабинет
Укажите e-mail, на который будет выслан код восстановления пароля.
На указанный вами адрес e-mail был выслан код подтверждения аккаунта. Введите полученный код для продолжения:
Введите новый пароль два раза:
SELECT new_sup, COUNT(new_sup)
FROM public."Data"
GROUP BY new_sup) nJOIN (
SELECT old_sup, COUNT(old_sup)
GROUP BY old_sup
) o ON o.old_sup = n.new_sup -- I'm gessing this is the join condition you want
;
Regards,
Greetings,I have two separate queries that work individually, returning a count from each column. I want to subtract New(COUNT) from Old(Count)I get an error when trying to run UNION? I would appreciate any pointers. -- COUNT NEW SUPPLIER--SELECT new_sup, COUNT(new_sup)FROM public."Data"GROUP BY new_sup This returnsCompany_D 35Company_E 30Company_F 30 SELECT newld_sup, COUNT(old_sup)FROM public."Data"GROUP BY old_sup This returnsCompany_A 1Company_B 2Company_D 35Company_E 30Company_F 30 SELECT new_sup, COUNT(new_sup) AS new_sup_count,old_sup, COUNT(old_sup) AS old_sup_count FROM( SELECT new_sup, COUNT(new_sup) AS new_sup_count FROM public."Data" GROUP BY new_sup UNION SELECT old_sup, COUNT(old_sup) AS old_sup_count FROM public."Data" GROUP BY old_sup new_sup_count - old_sup_count )GROUP BY new_sup
Greetings,
I have two separate queries that work individually, returning a count from each column.
I want to subtract New(COUNT) from Old(Count)
I get an error when trying to run UNION?
I would appreciate any pointers.
-- COUNT NEW SUPPLIER
--
SELECT new_sup,
COUNT(new_sup)
GROUP BY new_sup
This returns
Company_D 35
Company_E 30
Company_F 30
SELECT newld_sup,
COUNT(old_sup)
Company_A 1
Company_B 2
SELECT new_sup, COUNT(new_sup) AS new_sup_count,
old_sup, COUNT(old_sup) AS old_sup_count
FROM
(
SELECT
new_sup, COUNT(new_sup) AS new_sup_count
UNION
new_sup_count - old_sup_count
)
В списке pgsql-general по дате отправления: