Home > database >  Oracle a query
Oracle a query

Time:02-08

Is there a table a

Data structure is
Id name time
Zhang SAN 2020-01-01
1Zhang SAN 2020-01-02
1Zhang SAN 2020-01-03
1The 2020-01-01
2, dick, and harryThe 2020-01-02
2, dick, and harryThe 2020-01-03
2, dick, and harry3 fifty and 2020-01-01
3 fifty and 2020-01-02
3 fifty and 2020-01-03

Excuse me, how should write statements can be
Id name time
Zhang SAN 2020-01-01
1The 2020-01-02
2, dick, and harry3 fifty and 2020-01-03

Mean minimum ID in minimum time, in turn, until ID's biggest take the biggest time,
Could you tell me how to write, to think for a long time
  • Related