SELECT id,[date]=MAX(c1) FROM (SELECT id,c1 FROM tb UNION ALL SELECT id,c2 FROM tb UNION ALL SELECT id,c3 FROM tb UNION ALL SELECT id,c4 FROM tb UNION ALL SELECT id,c5 FROM tb ) x GROUP BY id
select id , date = max(c1) from ( select id , c1 from tb union all select id , c2 from tb union all select id , c3 from tb union all select id , c4 from tb union all select id , c5 from tb ) t group by id
select id,date=max(c1) from ( select id,c1 from tb union all select id,c2 from tb union all select id,c3 from tb union all select id,c4 from tb union all select id,c5 from tb ) a group by a.id
FROM
(SELECT id,c1 FROM tb
UNION ALL
SELECT id,c2 FROM tb
UNION ALL
SELECT id,c3 FROM tb
UNION ALL
SELECT id,c4 FROM tb
UNION ALL
SELECT id,c5 FROM tb
) x
GROUP BY id
(
select id , c1 from tb
union all
select id , c2 from tb
union all
select id , c3 from tb
union all
select id , c4 from tb
union all
select id , c5 from tb
) t
group by id
(
select id,c1 from tb union all
select id,c2 from tb union all
select id,c3 from tb union all
select id,c4 from tb union all
select id,c5 from tb
) a
group by a.id