Skip to content

Latest commit

 

History

History
39 lines (30 loc) · 357 Bytes

sql_best_practices.md

File metadata and controls

39 lines (30 loc) · 357 Bytes

Notes

Best Practices

SQL functions

SELECTION PARA

  • SELECT
  • FROM
  • DISTINCT
  • ORDER BY

FILTER PARA

  • LIMIT
  • WHERE
  • BETWEEN
  • IN
  • LIKE
  • IS NULL

JOINS

  • nINNER
  • OUTER
  • LEFT
  • SELF
  • FULL OUTER
  • CROSS JOIN

GROUPING

  • GROUP BY
  • HAVING

SET OPERATION

  • UNION