Hi all For you Sqlite experts out there is there an obvious kotlinlang #announcements

Hi all. For you Sqlite experts out there, is there...

Tim Malseed

03/29/2020, 11:09 AM

Hi all. For you Sqlite experts out there, is there an obvious, more concise representation of this:

Copy code

(SELECT count(*) FROM songs WHERE songs.albumId == albums.id AND songs.blacklisted == 0) as songCount

spand

03/29/2020, 12:29 PM

Looks fine. If this subquery is for count songs for many albums then you might get better performance using group by

3 Views