Skip to content
loading...

re: SQL 201: All About Aggregate Functions VIEW POST

FULL DISCUSSION
 

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;
code of conduct - report abuse