Stack Exchange network consists of 183 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
Visit Stack Exchange
Stack Internal
Knowledge at work
Bring the best of human thought and AI automation together at your work.
Explore Stack Internal
GROUP BY clause when using aggregationaggregate functions.x.quantity wouldn'twon't work.Try this :
SELECT x.productName, SUM(x.quantity) as quantity FROM ( SELECT productName, SUM(quantity*10) as quantity FROM Sample WHERE description IN ('GT','GE') GROUP BY productName UNION ALL SELECT productName, SUM(quantity*20) as quantity FROM Sample WHERE description IN ('VD') GROUP BY productName ) AS x GROUP BY x.productName GROUP BY clause when using aggregation functions.x.quantity wouldn't work.Try this :
SELECT x.productName, SUM(x.quantity) as quantity FROM ( SELECT productName, SUM(quantity*10) as quantity FROM Sample WHERE description IN ('GT','GE') GROUP BY productName UNION ALL SELECT productName, SUM(quantity*20) as quantity FROM Sample WHERE description IN ('VD') GROUP BY productName ) AS x GROUP BY x.productName GROUP BY clause when using aggregate functions.x.quantity won't work.Try this :
SELECT x.productName, SUM(x.quantity) as quantity FROM ( SELECT productName, SUM(quantity*10) as quantity FROM Sample WHERE description IN ('GT','GE') GROUP BY productName UNION ALL SELECT productName, SUM(quantity*20) as quantity FROM Sample WHERE description IN ('VD') GROUP BY productName ) AS x GROUP BY x.productName GROUP BY clause when using aggregation functions.x.quantity wouldn't work.Try this :
SELECT x.productName, SUM(x.quantity) as quantity FROM ( FROM ( SELECT productName, SUM(quantity*10) as quantity FROM Sample1Sample WHERE description =IN ('GT' or description = ,'GE') GROUP BY productName UNION ALL SELECT productName, SUM(quantity*20) as quantity FROM Sample1Sample WHERE description =IN ('VD') GROUP BY productName ) AS x GROUP BY x.productName Try this :
SELECT x.productName, SUM(x.quantity) as quantity FROM ( SELECT productName, SUM(quantity*10) as quantity FROM Sample1 WHERE description = 'GT' or description = 'GE' GROUP BY productName UNION ALL SELECT productName, SUM(quantity*20) as quantity FROM Sample1 WHERE description = 'VD' GROUP BY productName ) AS x GROUP BY x.productName GROUP BY clause when using aggregation functions.x.quantity wouldn't work.Try this :
SELECT x.productName, SUM(x.quantity) as quantity FROM ( SELECT productName, SUM(quantity*10) as quantity FROM Sample WHERE description IN ('GT','GE') GROUP BY productName UNION ALL SELECT productName, SUM(quantity*20) as quantity FROM Sample WHERE description IN ('VD') GROUP BY productName ) AS x GROUP BY x.productName Try this :
SELECT x.productName, SUM(x.quantity) as quantity FROM ( SELECT productName, SUM(quantity*10) as quantity FROM Sample1 WHERE description = 'GT' or description = 'GE' GROUP BY productName UNION ALL SELECT productName, SUM(quantity*20) as quantity FROM Sample1 WHERE description = 'VD' GROUP BY productName ) AS x GROUP BY x.productName ) AS x GROUP BY x.productName
Try this :
SELECT x.productName, SUM(x.quantity) as quantity FROM ( SELECT productName, SUM(quantity*10) as quantity FROM Sample1 WHERE description = 'GT' or description = 'GE' GROUP BY productName UNION ALL SELECT productName, SUM(quantity*20) as quantity FROM Sample1 WHERE description = 'VD' GROUP BY productName ) AS x GROUP BY x.productName
Try this :
SELECT x.productName, SUM(x.quantity) as quantity FROM ( SELECT productName, SUM(quantity*10) as quantity FROM Sample1 WHERE description = 'GT' or description = 'GE' GROUP BY productName UNION ALL SELECT productName, SUM(quantity*20) as quantity FROM Sample1 WHERE description = 'VD' GROUP BY productName ) AS x GROUP BY x.productName