Home Forums Programming General select distinct problem... RE: select distinct problem...

  • June 26, 2003 at 3:20 am

    #463189

    Try this

    select MIN (intID),vchrCode,vchrDescription,lngValue from TableName

    group by vchrCode,vchrdescription,lngvalue

    HAVING COUNT(vchrCode)=1

    [font="Verdana"]Markus Bohse[/font]