Snowflake SQL Improvements | Summit 2023

The SQL improvements in Snowflake can't stop, won't stop. In the last year, Snowflake has enriched Snowflake SQL to make queries shorter and easier to write. Sit in on this demo with Snowflake's Felipe Hoffa and Qinyi Ding to learn more about new syntaxes and functions and best practices on how to use them.
And don't forget...join us during our Data Cloud World Tour! Explore the power of data, apps & AI collaboration at one of 26 free Data Cloud World Tour events. You'll hear from fellow data, tech, and business leaders, while networking with local Snowflake customers and partners. Find an event near you: tinyurl.com/2s3dcu8x

[@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!

[@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...