Update Records Safely with WHERE

SQL

Technical Specification

Write an UPDATE query to set is_active = 0 for users who haven't logged in since 1 year ago.

Input/Output Samples

Input:last_login < '2024-01-01'

Output:Those users become inactive

Optimal Logic Path

UPDATE users
SET is_active = 0
WHERE last_login < DATE '2024-01-01';

Architectural Deep-Dive

UPDATE without WHERE can destroy data; always target only required subset.