help with Select statement

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Zvonko
    #1

    help with Select statement

    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




    Tags: None
    • SQL Menace
      #2
      Re: help with Select statement

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


      Denis the SQL Menace
      SQL Server Code,Tips and Tricks, Performance Tuning
      http://sqlservercode.blogspot.com/
      A blog about SQL Server, Books, Movies and life in general



      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

        Comment

        Previous template Next
        Working...