Hello to all,
I have following problem. I have a Table containing 2 Fields: Number and Date. The content could be following:
Now I want to select all numbers, but when there is a double (or more) Value (like 3), I would like to have the one with the youngest Date. So the Result of the Query should be:
I just can't figure out how to do this with the SELECT-Statement.
Would be very glad for any solutions.