SQLite Forum

Does table have rowid?
Login
== is just a habit from using language that differentiate between equality tests and assignment.

```
select coalesce((select rowid IS rowid from table limit 1), 1);
```

should work as well since `null is null` is True ...