pcsoft.us.windevCopyright 2026, PC SOFT25 Mar 2015 13:11:00 Z20 Mar 2015 10:18:00 ZHi Everyone I want to sum the price and quantity and divide it, but WD gives an error SELECT item, sum(price)/sum(quantity) FROM items_ordered GROUP BY item Any ideas on the correct syntax? Regards Marius30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51063-wd18-sql-syntax/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51063-wd18-sql-syntax-51177/read.awp25 Mar 2015 13:11:00 ZHi Steven, I'm not an ANSI or SQL-92 expert. I made a quick search and found out that many databases have different ways of h…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51063-wd18-sql-syntax-51177/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51063-wd18-sql-syntax-51177/read.awp[WD18] - Sql syntaxguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51063-wd18-sql-syntax-51155/read.awp25 Mar 2015 05:48:00 ZThanks Steven Noted. Regards Mariushttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51063-wd18-sql-syntax-51155/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51063-wd18-sql-syntax-51155/read.awp[WD18] - Sql syntaxguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51063-wd18-sql-syntax-51148/read.awp24 Mar 2015 16:21:00 ZHi Alexandre, I didn't know that. It would be nice if we had it in WD language also .. But is this an ANSI thing ? Do you how …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51063-wd18-sql-syntax-51148/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51063-wd18-sql-syntax-51148/read.awp[WD18] - Sql syntaxguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51063-wd18-sql-syntax-51141/read.awp24 Mar 2015 13:45:00 ZHi Steven, A division by 0 in HFSQL will not produce an error but will return 0. (We wished we had such an option in WinDev b…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51063-wd18-sql-syntax-51141/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51063-wd18-sql-syntax-51141/read.awp[WD18] - Sql syntaxguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51063-wd18-sql-syntax-51140/read.awp24 Mar 2015 13:38:00 ZHi Marius, although Aries code pointed you to the right direction, there is a little problem. Depending on your backend databa…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51063-wd18-sql-syntax-51140/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51063-wd18-sql-syntax-51140/read.awp[WD18] - Sql syntaxguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51063-wd18-sql-syntax-51097/read.awp23 Mar 2015 10:07:00 ZHi Arie Spot on. Thanks!!!! Regards Mariushttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51063-wd18-sql-syntax-51097/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51063-wd18-sql-syntax-51097/read.awp[WD18] - Sql syntaxguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51063-wd18-sql-syntax-51095/read.awp23 Mar 2015 09:25:00 ZMarius, try this SELECT item, sum_price, sum_quantity, sum_price / sum_quantity FROM ( SELECT item, SUM(price) as sum_pr…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51063-wd18-sql-syntax-51095/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51063-wd18-sql-syntax-51095/read.awp[WD18] - Sql syntaxguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51063-wd18-sql-syntax-51094/read.awp23 Mar 2015 08:03:00 ZI'm struggling with the issue! I use the "WDSQL Tool" to test the code. If I run this query in MS SQL SELECT item, SUM(…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51063-wd18-sql-syntax-51094/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51063-wd18-sql-syntax-51094/read.awp[WD18] - Sql syntaxAndrewpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51063-wd18-sql-syntax-51066/read.awp20 Mar 2015 12:17:32 ZWhat's the error that WinDev tells you? -- that should prove helpful to solving the issue... ... My guess is that you have a…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51063-wd18-sql-syntax-51066/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51063-wd18-sql-syntax-51066/read.awp[WD18] - Sql syntaxguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51063-wd18-sql-syntax-51068/read.awp20 Mar 2015 12:08:00 ZThanks Derek. Your syntax pointed me in the correct direction. I should only use one SUM and not TWO as in your example. R…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51063-wd18-sql-syntax-51068/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51063-wd18-sql-syntax-51068/read.awp[WD18] - Sql syntaxguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51063-wd18-sql-syntax-51064/read.awp20 Mar 2015 11:07:00 ZMarius In the query generator add a 'calculated item' as price/quantity - give it a name you can recognise. This will add a …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51063-wd18-sql-syntax-51064/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/51063-wd18-sql-syntax-51064/read.awp[WD18] - Sql syntax