Hi,
I am migrating my application from MySQL to Postgresql and have met following situation:
SELECT
(sum(sold_price)/(select sum(sold_price) from car_archive))*100 as CA_pcent,
reason_text
FROM car_archive
group by reason_text
order by CA_pcent desc
works perfectly in MySQL, but not in Postgresql. The problem seems to be the nested select which should deliver a sum of the whole table, but it does not.
If I replace this nested select with a fix value, then it works:
SELECT
(sum(sold_price)/(333))*100 as CA_pcent,
reason_text
FROM car_archive
group by reason_text
order by CA_pcent desc
Has someone a solution for that situation?
Thanks,
Hubert Retif
