I am facing an issue while retrieving data from the room database with the help of a nested query. The query is working properly for the plain SQLite database. I have tested the scenario within the SQLCipher for the Android test suite. It shows the result as “FAILED”.
Using latest version of SQLCipher 4.4.2 & room database version is 2.2.6.
Am I doing wrong or is there any other way to get the latest record from the multiple records of the same date?
select date_value, price, (select id from table_product t2 where t.date_value = t2.date_value order by id desc limit 1) as id from table_product t where date_value between 'start_date' and 'end_date' group by date_value order by date_value