Question

Given the RATE table with rate_id, id_del and value columns, what is the result of the following query execution?

DELETE FROM RATE where rate_id in (SELECT rate_id FROM RATE WHERE id_del=1) AND id_del=0

Cosmo · Accepted Answer

Query tries to delete a record with id_del=0 AND id_del=1 at the same time. Obviously, nothing will be deleted from the database.

Cosmo · Accepted Answer

The query will be executed, but will not delete any records

Cosmo · Answer

The query will delete from the RATE table all records with id_del = 1

Cosmo · Answer

The query will delete from the RATE table all records with id_del = 0

Cosmo · Answer

The query will delete all records from the RATE table

Cosmo · Answer

The query will not be executed