Home Forums SQL Server 2008 T-SQL (SS2K8) Return unique rows RE: Return unique rows

  • February 12, 2016 at 10:58 am

    #1858455

    If you don't need DateLastTrans in your resultset, and if the other 3 columns are unique identifiers, then why are you even looking at the 4th column?

    select DISTINCT contractno, Address1, dateJoined

    from tableTest

    where datejoined between 2012-12-01 and 2015-12-31

    "If I had been drinking out of that toilet, I might have been killed." -Ace Ventura