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 |
- [SQL] Nested select Hubert Retif
- Re: [SQL] Nested select imad
- Re: [SQL] Nested select Tom Lane
- Re: [SQL] Nested select Aaron Bono
- Re: [SQL] Nested select Scott Marlowe