Posted by SQL Menace on 09/20/06 13:08

select sifrob,katbroj,sum(kol) as kol
from Query_Result
group by sifrob,katbroj


Denis the SQL Menace
http://sqlservercode.blogspot.com/


Zvonko wrote:
> Hi!
>
> This is my table:
>
> CREATE TABLE [Query_Result] (
> sifrob VARCHAR(13),
> katbroj VARCHAR(15),
> kol FLOAT
> )
>
>
> This is some values:
>
> INSERT INTO [Query_Result] ([sifrob], [katbroj], [kol])
> VALUES
> ('49501879', 'G-46052', 1)
> INSERT INTO [Query_Result] ([sifrob], [katbroj], [kol])
> VALUES
> ('49501879', 'G-46052', 3)
> INSERT INTO [Query_Result] ([sifrob], [katbroj], [kol])
> VALUES
> ('49501910', 'G-46935', 1)
> INSERT INTO [Query_Result] ([sifrob], [katbroj], [kol])
> VALUES
> ('49508122', 'G-46944', 1)
> INSERT INTO [Query_Result] ([sifrob], [katbroj], [kol])
> VALUES
> ('49508698', 'G-50314', 1)
> INSERT INTO [Query_Result] ([sifrob], [katbroj], [kol])
> VALUES
> ('49502695', 'G-51201', 1)
>
> As you can see some vaules are duplicated and only the 'kol' is
> different. I would like to write a SELECT statements that will get all the
> values from table, but on the duplicated ones that I get it once and the
> 'kol' column is sum of the two 'kol' values ( so if we have 499501879 the
> 'kol must be 4.
>
> Please help.
>
> Best regards,
> Zvonko

• Next in forum: Re: Help needed with DATETIME Arithmetic
• Prev in forum: Re: Newbie Question on DB Maintenance Plan
• Thread view: Re: help with Select statement

[Reply to this message]