SQLite Forum

Does table have rowid?
Login
>select coalesce((select rowid == rowid from table where rowid is not null limit 1), 1);

Appears to work; thanks. I need to test it further.

I am intrigued by == since usually SQL sees = as assignment or comparison depending on context.