Post reply

rows are repeating 2 times,how to avoid that

  • March 29, 2012 at 10:20 am

    #266378

    hi

    i am getting result like this

    1 product1 12.34 32.11

    1 product1 null null

    2 product2 15.00 15.35

    2 product2 null null

    i just want my result like this

    1 product1 12.34 32.11

    2 product2 15.00 15.35

    i tried to use distinct ,doesnt work.

    please help

  • March 29, 2012 at 10:32 am

    #1466485

    How about using NOT NULL in a WHERE?

    _________________________________
    seth delconte
    http://sqlkeys.com

  • March 29, 2012 at 11:05 am

    #1466509

    Unfortunately, without the source data or the query you are running there really isn't much more we can do to help.

    I suggest that you take the time to read the first article I reference below on "Asking for help." Following the instructions provided in that article regarding what and how you should post the information we need to help you and you will get better answers to your questions. In addition, you will also get tested code in return.

  • March 29, 2012 at 11:26 am

    #1466528

    thanks so much , you save me today

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply