Post reply

selecting the duplicate data

  • June 13, 2005 at 1:49 pm

    #88664

    Hi guys

    I have a table like this below. How can I select the duplicate "colorNO" in the table, when I supply the "OID"

    i.e. when i give OID = 666, then the query should display '540'

     

    ID         OID            ColorNO

    --------------------------------

    153       666            Test Shade 1       

    154       666            5M 3               

    155       666            540                

    156       666            540 

     

    any help will be appreciated

  • June 13, 2005 at 2:13 pm

    #565113

    Select ColorNO from dbo.YourTable where OID = 666 group by ColorNO

    having count(*) > 1

  • June 13, 2005 at 2:21 pm

    #565116

    thanks

  • June 13, 2005 at 2:23 pm

    #565117

    HTH

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

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