Basic SQL Select Statement

Job ID: 30897302

Budget: $10 – $30 USD

Table contains columns: ShipName, ShipDate

ShipName ShipDate
a 1/1/2021
b 1/2/2021
b 1/4/2021
a 1/5/2021
c 1/8/2021
c 1/9/20221

I want to create a query that outputs the most recent date for each ShipName column:

a 1/5/2021
b 1/4/2021
c 1/9/2021

Related categories: SQL MySQL Database Programming Microsoft SQL Server