Mysql - Join Same Rows with null entries
I have mysql table with format like this
Name - Date1 - Date2
After I got result
A - NULL - 1
A - 2 - NULL
I want to join these results as
A - 2 - 1
How t开发者_如何学Pythono achieve this ?
SELECT Name,
MAX(Date1),
MAX(Date2)
FROM tbl
GROUP BY Name
精彩评论