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
mysql DISTINCT & ORDER BY
-
- Posts: 195
- Joined: Tuesday 26th September 2017 3:17pm
- Location: NW England
Re: mysql DISTINCT & ORDER BY
This seems to work:
SELECT DISTINCT TransRef, TransDate FROM Transactions ORDER BY TransDate;
-
- Posts: 195
- Joined: Tuesday 26th September 2017 3:17pm
- Location: NW England
Re: mysql DISTINCT & ORDER BY
Thank you so much.
I thought that was where I'd started - must have been mistaken
Thanks again
I thought that was where I'd started - must have been mistaken
Thanks again
Re: mysql DISTINCT & ORDER BY
Your very welcome.