0

My table looks like this:

Document   Date       Time
00C00001   1/1/2022   0231
00C00001   1/2/2022   1208
00C00002   1/3/2022   1142
00C00002   1/3/2022   1453

I need to select the first occurrence of each document or the Min(Time) of the Min(Date). Is there a way of performing this without a sub query. If not, that's okay too. My actual example is just a bit more complex. Thank you in advance.

result should look like this:

Document   Date       Time
00C00001   1/1/2022   0231
00C00002   1/3/2022   1142
Conner
  • 215
  • 2
  • 18

0 Answers0