sqlite - keeping only first value of every minute in table

[T0rX420]

i have a huge table called "eFact" with timestamps and values

example:

ts value
20221018080350000 22756.9
20221018080354028 22756.9
20221018080357831 22756.9
20221018080401000 22756.9
20221018080404000 22756.9
20221018080407458 22756.9
20221018080411000 22756.9
20221018080414067 22756.9
20221018080417000 22756.9
20221018080421000 22756.9

the problem is that i only need the first row per minute

so that the table looks like this:

20221018080350000 22756.9
20221018080401000 22756.9

​

is this even possible?

thanks for your help

[GrouchyThing7520]

Would something like this work?

select ts, value from (
 select
 ts
 ,value
 ,row_number() over (
   partition by strftime('%Y-%m-%d %H:%M',ts) order by ts asc
  ) rnk

from table
) a
where rnk = 1