Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2013
    Posts
    1

    Unanswered: How to elliminate double values from results

    Hi,
    I need help of elliminate double values from results.
    Here you see my query and results:

    select
    account,
    Room,
    sum(amounts) as booked
    from table1
    join ...
    where --
    group by
    account,
    Room
    having count(accont) =1

    And results come:


    Account,Room,booked
    53925,'E 4.000000
    54834,'L 1.000000
    60817,'A 0.000000
    60816,'A 1.000000
    60816,'D 1.000000
    60816,'C 2.000000
    62698,'B 8.000000
    62798,'D 2.000000

    I need that 60816 will not comes to report results.
    Please manage, how I can do that ?

    Thank you for help advance!

    Blue

  2. #2
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    Remove room from your select and group by

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •