Gambas ONE

I hope it's not a problem posting a mysql issue here!
I have a table 'transactions' with a number of fields including 'TransRef and TransDate). I want to select 'TransRef' as DISTINCT and ORDER BY TransDate.
I've read a number of learned items on this but can't solve the problem.
For example, the table could look like this:-
TransRef TransDate otherfields
0123 12/31/2017
0123 12/31/2017
0144 01/30/2017
0144 01/30/2017
0110 03/10/2017
0110 03/10/2017

This is the result I'm seeking
0144 01/30/2017
0110 03/10/2017
0123 12/31/2017

This seems to work:

SELECT DISTINCT TransRef, TransDate FROM Transactions ORDER BY TransDate;

Thank you so much.
I thought that was where I'd started - must have been mistaken
Thanks again

Your very welcome.