Forum Discussion

sea's avatar
sea
Frequent Visitor
9 years ago
Solved

max date value

Hello,

 

+--------------+-------------+
| CUSTOMER     |    DATE     |
+--------------+-------------+
| CUSTOMER 1   |   2.3.2016  |
| CUSTOMER 1   |   3.4.2015  |
| CUSTOMER 1   |   6.6.2017  |
| CUSTOMER 2   |   9.2.2015  |
| CUSTOMER 2   |   7.8.2017  |
| ............ |  ........   |
+--------------+-------------+

How can only show maximum customer dates in this form:

 

+--------------+-------------+
| CUSTOMER     |    DATE     |
+--------------+-------------+
| CUSTOMER 1   |   6.6.2017  |
| CUSTOMER 2   |   7.8.2017  |
| ............ |  ........   |
+--------------+-------------+

Thank you!

1 Reply