Query using SUM

Question

I need to fix this query so that it will give me the part number, part description and on hand value for each part in the SG class. This is what I have so far. but it just gives me the total value of all the items in the SG class. How can I have it where it will give me the total based on the description?

SELECT PART_NUM, DESCRIPTION, SUM(ON_HAND * PRICE) AS ON_HAND_VALUE
FROM PART
WHERE CLASS = 'SG'

PART_NUM    DESCRIPTION     ON_HAND_VALUE
BV06          Home Gym         48282.75

Part Table "All the items in the SG class"

PART_NUM    DESCRIPTION     ON_HAND     CLASS   WAREHOUSE   PRICE
    BV06       Home Gym       45          SG         2      794.95
    KV29       Treadmill       9          SG         2      1390.00

SDReyes · Accepted Answer · 2010-04-27 16:58:02Z

1

How can I have it where it will give me the total based on the description?

Add the Group By clause

SELECT PART_NUM, DESCRIPTION, SUM(ON_HAND * PRICE) AS ON_HAND_VALUE
FROM PART
WHERE CLASS = 'SG'
GROUP BY DESCRIPTION

answered Apr 27, 2010 at 16:58

SDReyes

9,96416 gold badges58 silver badges93 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

DRapp · Accepted Answer · 2010-04-27 16:57:37Z

0

Add..

Group By Part_Num, Description

answered Apr 27, 2010 at 16:57

DRapp

48.3k13 gold badges80 silver badges149 bronze badges

Collectives™ on Stack Overflow

Query using SUM

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related