SQLite Forum

Querying first of each month
Login
HI

My table has columns: id(string), logfile(string), timestamp(date). I would like to get the filename corresponding to the first entry for each month (based on timestamp) for every unique id (There are multiple entries per id, but I need the first for each month). How might I write this query?

thanks!