Re: Simple SQL Total question

[Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

select part#, sum(qtyshipped) from yourfile group by part#

On 12/13/2013 10:52 AM, Hoteltravelfundotcom wrote:
> I have been unable to sum data in SQL. I am trying to create a View that
> takes all detail qty for an item and creates summary columns
>
> PART#       QTYSHIPPED    INVOICE
>
> 123                 1                   12345
> 123                  1                   12346
> 123                  1                    123457
> 123                  1                     123458
> 123                   1                    123459
>
> I want to create
>
> Part# = 123
> QTYSHIPPED = 5
>
> dont care about invoice.