SQL Tricks

Where 1=1

1=1 as first statement after where clause so that you can easily comment/uncomment (no need to add / remove "and" keyword having count(*) > 1 https://www.youtube.com/watch?v=_a7qa0pEhyE

Searching For "Duplicates" at a Specific Grain

https://www.youtube.com/shorts/6eBAvqURutI

Fill attributes that may be missing by using self join (to a distinct query)

Pk_ToDo: Create youtube short or video and post link here

Where 1=1
Searching For "Duplicates" at a Specific Grain
Fill attributes that may be missing by using self join (to a distinct query)

Where 1=1​

Searching For "Duplicates" at a Specific Grain​

Fill attributes that may be missing by using self join (to a distinct query)​

Where 1=1

Searching For "Duplicates" at a Specific Grain

Fill attributes that may be missing by using self join (to a distinct query)