Developer Reference

How to Use the SQL Reference

Step-by-step guide to looking up SQL syntax for SELECT, JOIN, aggregate functions, and more using the DevHexLab SQL Reference.

Tool Used

SQL Reference

Open tool
1

Open the SQL Reference

Navigate to /tools/reference/sql-reference.

2

Find the clause or function

Search by keyword (like JOIN or GROUP BY) or browse by category: queries, aggregates, filtering, subqueries, and DDL statements.

3

Read the syntax and example

Each entry shows the correct syntax, a minimal working example, and a brief description of what it does.

4

Copy the example

Click Copy to grab the SQL snippet and paste it into the SQL Formatter tool or directly into your query editor.

All done!

You are ready to use SQL Reference like a pro.

Try it now
All guides