HexLibraryHexLibrary
</> HexCodeSign inSign up
PythonJavaScriptTypeScriptCC++JavaPHPGoRustRubyBashSQLLuaPerlCOBOLPascalDelphiFortranDartSwiftC#JuliaGroovyRElixirHaskellKotlinScalaClassic ASPClipperMS-DOS
LESSONS
Introduction to SQL (SELECT)Tables (CREATE & INSERT)Filtering (WHERE)Sorting & LimitingAggregate FunctionsUpdate & DeleteJoins (JOIN)
REFERENCE
📖 Overview
🔎 Querying (SELECT)
🗃️ Creating a Table
✏️ Inserting & Modifying Data
🧲 Filtering (WHERE)
🔢 Sorting & Limiting
📊 Aggregate Functions
🔗 Joins (JOIN)
SQL›REFERENCE

SQL — Command Reference

SQL's most used commands — the universal language of querying databases. Each example is a complete script (create table, insert data, query). Each includes an explanation and a working example.

7 categories · 15 commands

🔎

Querying (SELECT)

The basis of data retrieval.

SELECTSELECT *DISTINCT
3 commands →
🗃️

Creating a Table

Defining data structure.

CREATE TABLE
1 commands →
✏️

Inserting & Modifying Data

INSERT, UPDATE, DELETE.

INSERT INTOUPDATEDELETE
3 commands →
🧲

Filtering (WHERE)

Selecting rows based on a condition.

WHERELIKEIN / BETWEEN
3 commands →
🔢

Sorting & Limiting

ORDER BY and LIMIT.

ORDER BYLIMIT
2 commands →
📊

Aggregate Functions

COUNT, SUM, AVG and GROUP BY.

COUNT / SUM / AVGGROUP BY
2 commands →
🔗

Joins (JOIN)

Relating two tables.

INNER JOIN
1 commands →
HexLibraryHexLibrary

Learn programming more clearly. Every command is explained line by line with colors, reinforced with runnable exercises, test your code instantly — all in one place, free.

Learn

  • Home
  • Languages & Lessons
  • HexCode

Company

  • About
  • Contact

Legal

  • Privacy Policy
  • Terms of Use

Other Projects

  • HexToolz
  • Free Service Manuals
© 2026 HexLibrary · The clearest way to learn code