select email,maxdate=(case when date1<date2 then date2 else date1 end) from (SELECT Email, MAX(lastUpdateDate) AS Date1 ,MAX(AddDate) AS Date2
FROM myTable
GROUP BY Email) b
FROM myTable
GROUP BY Email) b
调试欢乐多
SELECT Email, MAX(lastUpdateDate) AS Date1, MAX(AddDate) AS Date2
FROM myTable
GROUP BY Email) b
SELECT Email,MAX(case when lastUpdateDate>AddDate then lastUpdateDate else AddDate end) AS maxDate
FROM myTable
GROUP BY Email