Top SQL Questions

Kevin Ashley

SQL Query to Find Most Recent Backup of Each Database on Server

Write a SQL query to find the most recent backup of each database on a server.

Problem

Write a SQL query to find the most recent backup of each database on a server.
Input:
Server:
DB1
DB2
DB3
Backup1: DB1 –> 2018-01-01
Backup2: DB2 –> 2018-01-02
Backup3: DB3 –> 2018-01-03
Output:
Backup1
Backup2
Backup3

Solution

This solution is in SQL. Our A.I. can create solutions in multiple languages.
by AskAI 
Test
A.I. Evaluation of the Solution

The candidate's solution does not demonstrate a level of completeness and does not solve the problem. The general approach is not clear.

Evaluated at: 2022-11-02 16:09:40