SQL antipatterns:  SELECT DISTINCT

Uli Bethke August 9, 2022

The DISTINCT operator The DISTINCT operator is used to eliminate duplicates in a resultset, e.g. we can use it to identify the unique number of customers who made a purchase. We run the following query against the Sample Data provided with Snowflake data cloud platform. SELECT DISTINCT SS_CUSTOMER_SK from "SAMPLE_DATA"."TPCDS_SF10TCL"."STORE_SALES"; 1 SELECT DISTINCT SS_CUSTOMER_SK from ...

Read More


Uli Bethke June 7, 2022

Overview The strategic road network (SRN) is a vital national asset, supporting economic growth, regional development, and employment opportunities across England and the rest of the UK. It connects families, communities and businesses, enriching the lives of many citizens. Billions of miles are traveled on the SRN each year. The vast majority of these are ...

Read More

FlowHigh [Video]: Visualise, format, optimise and parse your SQL

Uli Bethke May 31, 2022

Contact us if you would like to be part of the private preview of the FlowHigh SQL revolution

Read More

ERA5 variables

Uli Bethke May 19, 2022

Single Level variables   Variable Label U10 10m u-component of wind V10 10m v-component of wind D2M 2m dewpoint temperature T2M 2m temperature MSL Mean sea level pressure MWD Mean wave direction MWP Mean wave period SST Sea surface temperature SWH Significant height of combined wind waves and swell SP Surface pressure TP Total precipitation ...

Read More
1 2 3 94