Hopefully this will be an easy one for someone.
I am trying to write a SELECT statement that pulls the row with the least time for each Special Number.
Example data would be:
Time Special Number
3:25:00 1
3:26:00 1
3:25:30 2
3:26:30 2
The expected output would be:
3:25:00 1
3:25:30 2
I don't have much because I am really a novice SQL user.
SELECT Time, Special Number
WHERE
Any help would be greatly appreciated!