SQL Sever: max of date : Table 1
--------
RefId
-----
1
2

Table 2
--------
RefId             Date
-----             -----
1                 29/03/2018 07:15
1                 29/03/2018 07:30
2                 29/03/2018 07:35
2                 29/03/2018 07:40

i would like the result to be as follows (Refid and the max(date) from table 2 for that refid)

1                 29/03/2018 07:30
2                 29/03/2018 07:40