FORUM Everything about SQL Elements of a SQL Query

Elements of a SQL Query

Hi, so I learn better by knowing all the elements of the topic I’m learning, like “the big picture”, in this case I want to know the elements of a SQL query, I have the following:

  • Statements: select, from, order by
  • Operators: as, or, in
  • functions (here we have scalar and aggregate): count, sum, min, cast

I don’t know if I’m missing something, also I don’t know how the AND and BETWEEN - AND are catalogued

Thank you all!


Hi @ecasanova95 👋

I guess the closest thing on SQL Habit to a catalog of statements/operators/etc is SQL Reference you can find in the SQL Editor.

You’ll see it in every lesson, exercise or on the Playground page.

SQL Reference on SQL Habit