Snowflake SQL Improvements | Summit 2023

[@sharma_ji_in_uk]

group by all is helpful for deduplication . Select * exclude(lastupdatetime) ,count(1) group by all having count(1)>1

[@Myhands14]

Awesome changes!

[@snowflakedevelopers]

Thanks!

[@k.r.2038]

I think GROUP BY ALL should work like DISTINCT if you do not have an aggregation function. Would be better than ignoring it. Many folks use GROUP BY as a replacement of DISTINCT...