Daniel Bowlin (9/22/2010)
Try a CTE or temp table to get your DISTINCT then join that back to a SELECT where you query the data and constrain on the MIN or MAX of Column C
Thank you for your reply.
I solved my issue as follows :
Select Distinct ColumnA, Max(ColumnB) As ColumnB, Max(ColumnC) As ColumnC
Group By ColumnA
Thanks again Daniel, and of course Thank You Luke.