Deleting with Where

Just like select, delete supports a where clause to target specific rows instead of wiping the entire table:

delete from main.users where id = 2;

This removes only Bob. The response tells you exactly how many rows were affected - in this case, 1 row changed.

Confirm only Alice and Charlie remain:

select * from main.users;

The same comparison operators from select where apply here too.