SQL Cheat Sheet

select

from

where

group by

having

oerder by

limit

=

!=

<

>

<=

>=

True

False

not

in

between

min()

max()

avg()

count()

median()

mode()

stddev()

w/group by

w/ having

w/ distinct

concat()

replace()

reverse()

trim()

upper()

lower()

len()

str()

wildcards (%)

like / ilike

day()

month()

year()

getdate()

date_add()

datediff()

date_trunc()

date_format()

inner join

left join

outer join

self join

anti join

joining on multiple keys

joining on a condition

cast()

coalesce()

case when

ifnull()

iff()

listagg()

except

Union

Union All

Intersect

Minus

sum()

count()

avg()

max()

min()

row_number()

rank()

denserank()

lead()

lag()

over( ...

partition by<

order by

)

CTEs

UDFs

Data Modeling

Subqueries