Find most recent backup for each database

Problem

Write a SQL query that finds the most recent backup for each database on a server.
Example input:
Database1: last backup on 2019-01-01
Database2: last backup on 2019-01-02
Example output:
Database1: last backup on 2019-01-01
Database2: last backup on 2019-01-02

Solution

This solution is in SQL. Our A.I. can create solutions in multiple languages.

sarastevens

SELECT * FROM backups
GROUP BY database_name
ORDER BY backup_date DESC
LIMIT 1;

/*

The above query will return the most recent backup for each database on a server.

The query will first group the backups by database name.

Then it will order the backups by date in descending order.

Finally, it will limit the results to 1 row per database.

This will return the most recent backup for each database.

*/