Return deleted rows in sqlite

Question

It's not efficient to do two queries like SELECT * FROM TABLE WHERE clause and then DELETE * FROM TABLE WHERE clause.

So I want to make DELETE query and return deleted rows (one query).

I tried to do:

DELETE OUTPUT DELETED.*
FROM table
WHERE clause

But I have an error:

SQLite exception: near "OUTPUT": syntax error

How to make it correctly or maybe there is another alternative way to return deleted rows?

Answer 1

The DELETE statement has no OUTPUT clause.

After doing the SELECT, all the important data is in the cache, so the DELETE will run quickly.

And because SELECT plus DELETE is the only way, it is the most efficient way.