T
thelarch
I have a table and it contains values like these ones below:
18/05/2006 50
18/05/2006 35
19/05/2006 50
19/05/2006 69
20/05/2006 55
20/05/2006 33
Basically i want my query to output the date and the highest number on
that date. Therefore the result being:
18/05/2006 50
19/05/2006 69
20/05/2006 55
Im not sure which was to go about this. Any help would be appreciated.
Thanks
18/05/2006 50
18/05/2006 35
19/05/2006 50
19/05/2006 69
20/05/2006 55
20/05/2006 33
Basically i want my query to output the date and the highest number on
that date. Therefore the result being:
18/05/2006 50
19/05/2006 69
20/05/2006 55
Im not sure which was to go about this. Any help would be appreciated.
Thanks