sqlite - In android 10 or above GROUP BY not woking when i am fetching data from gallery using content resolver

Question

I am creating an app which fetch photos from gallery its a photobook app. Every thing is working fine when my android SDK lower than 29 but when, I update to 29 or 30 my all SQL query generate errors it says near "GROUP": syntax error (code 1 SQLITE_ERROR[1]) is there any other solution or hack please let me know, I already try to remove GROUP BY and fetch data but its too much time taking..

question from:https://stackoverflow.com/questions/65885549/in-android-10-or-above-group-by-not-woking-when-i-am-fetching-data-from-gallery

Answer 1

Waitting for answers