Column1 Column2 Column3 Column4 220 2 1506 17 220 1 1506 15 218 1 1497 5 217 2 1499 10 217 1 1601 11
Column1 Column2 Column3 Column4 220 2 1506 17 218 1 1497 5 217 2 1499 10
select Max(a.Column1)as Column1 , Column2 from table a inner join table b on a.Column2=b.Column2 group by Column2
SELECT T.* FROM ( SELECT Column1, Max(Column2) Column2 FROM TABLE GROUP BY Column1 ) A INNER JOIN TABLE T on A.Column1 = T.Column1 AND A.Column2 = T.Column2
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)