Show Menu

2 Etl Cheat Sheets

2 Cheat Sheets tagged with Etl

2 Pages
  (0)
2 Pages
  (0)
DRAFT:
Summarizing the key SQL statements Missing data: WHERE IS NOT NULL WHERE IS NULL COUNT(*) GROUP BY ORDER BY String Functions: SUBSTRING(), LTRIM(), RTRIM(), LEFT(), RIGHT(), CHARINDEX(), LEN(), ISNUMERIC(), ISDATE() Set Operations EXCEPT­/MINUS INTERSECT UNION Dropping Duplicates row_number() OVER ( PARTITION BY WHERE > 1 Replace Through Regular Expressions CASE with LIKE
30 Sep 22

Cheat Sheets by Tag


Top Tags

New Tags