SQLite Forum

Querying first of each month
Login
As Stephan said: more info is needed.

Because (technically): SELECT * FROM ....   is also a good answer to your question. (It just gives more data than you want)

You did not even give the tablename, we cannot guess...