GROUP BY is often unnecessary since it is already implicit in the query. For this reason, we chose to interpret GROUP BY implicitly in QuestDB.
So both examples would run fine without GROUP BY.
select artist, count(artist) as artist_count from dbo.music_charts
select artist, song, count(artist) as artist_count from dbo.charts where artist = 'mariah carey' order by artist_count desc, song, artist;
Are you sure you want to hide this comment? It will become hidden in your post, but will still be visible via the comment's permalink.
Hide child comments as well
Confirm
For further actions, you may consider blocking this person and/or reporting abuse
We're a place where coders share, stay up-to-date and grow their careers.
GROUP BY is often unnecessary since it is already implicit in the query. For this reason, we chose to interpret GROUP BY implicitly in QuestDB.
So both examples would run fine without GROUP BY.