Is 123 Toolbox free to use?

Yes. Every tool on 123 Toolbox is free and runs directly in your browser — no account or payment required.

Are my files uploaded to a server?

No. Files and text are processed locally in your browser and are not uploaded by 123 Toolbox, except for a few tools that clearly depend on an external resource.

What kinds of tools are available?

123 Toolbox includes hundreds of tools for PDFs, images, developers, designers, Khmer language, geospatial data, security, math, and everyday work.

Which languages does 123 Toolbox support?

The interface supports English, Khmer, and a bilingual English–Khmer mode.

How do I use SQL Cheat Sheet?

Browse the SQL reference groups Click copy on any query Paste it into your SQL editor

Is SQL Cheat Sheet free to use?

Yes. SQL Cheat Sheet on 123 Toolbox is free and runs directly in your browser — no account or payment required.

Do I need to install anything to use SQL Cheat Sheet?

No installation is required. It runs in a modern web browser and processes your input locally on your device.

Is SQL Cheat Sheet available in Khmer?

Yes. The 123 Toolbox interface supports English, Khmer, and a bilingual English–Khmer mode.

All tools / ឧបករណ៍ទាំងអស់SQL Cheat Sheet — សន្លឹកយោង SQL

SQL Cheat Sheet

សន្លឹកយោង SQL

Quick reference for standard SQL — SELECT, WHERE, JOINs, GROUP BY / HAVING, aggregates, INSERT / UPDATE / DELETE, CREATE TABLE, and indexes, each with a copyable example. / ឯកសារយោងរហ័សសម្រាប់ SQL ស្ដង់ដារ — SELECT, WHERE, JOIN, GROUP BY / HAVING, អនុគមន៍សរុប, INSERT / UPDATE / DELETE, CREATE TABLE និងលិបិក្រម — នីមួយៗមានឧទាហរណ៍ដែលអាចចម្លងបាន។

SELECT basics / SELECT មូលដ្ឋាន

Select specific columns / ជ្រើសរើសជួរឈរជាក់លាក់

SELECT first_name, last_name FROM users;

Select all columns / ជ្រើសរើសជួរឈរទាំងអស់

SELECT * FROM users;

Distinct values / តម្លៃដោយឡែក

SELECT DISTINCT country FROM users;

Column alias / ឈ្មោះកាត់ជួរឈរ

SELECT price * qty AS total FROM orders;

Limit results / កំណត់ចំនួនលទ្ធផល

SELECT * FROM users ORDER BY id LIMIT 10;

Sort results / តម្រៀបលទ្ធផល

SELECT name FROM products ORDER BY price DESC;

WHERE filtering / តម្រងជាមួយ WHERE

Comparison operators / ប្រមាណវិធីប្រៀបធៀប

SELECT * FROM users WHERE age >= 18;

Text pattern (LIKE) / លំនាំអក្សរ (LIKE)

SELECT * FROM users WHERE email LIKE '%@gmail.com';

Set membership (IN) / ជាសមាជិកសំណុំ (IN)

SELECT * FROM orders WHERE status IN ('paid', 'shipped');

Range (BETWEEN) / ចន្លោះ (BETWEEN)

SELECT * FROM products WHERE price BETWEEN 10 AND 50;

Null check / ពិនិត្យតម្លៃ NULL

SELECT * FROM users WHERE phone IS NOT NULL;

Combine with AND / OR / NOT / ផ្សំជាមួយ AND / OR / NOT

SELECT * FROM users
WHERE country = 'KH' AND age >= 18 AND NOT banned;

JOINs / JOIN (ការភ្ជាប់តារាង)

INNER JOIN — matching rows / INNER JOIN — ជួរដែលត្រូវគ្នា

SELECT u.name, o.total
FROM users u
INNER JOIN orders o ON o.user_id = u.id;

LEFT JOIN — keep all left rows / LEFT JOIN — រក្សាជួរខាងឆ្វេងទាំងអស់

SELECT u.name, o.total
FROM users u
LEFT JOIN orders o ON o.user_id = u.id;

RIGHT JOIN — keep all right rows / RIGHT JOIN — រក្សាជួរខាងស្ដាំទាំងអស់

SELECT u.name, o.total
FROM orders o
RIGHT JOIN users u ON o.user_id = u.id;

FULL OUTER JOIN — all rows / FULL OUTER JOIN — ជួរទាំងអស់

SELECT u.name, o.total
FROM users u
FULL OUTER JOIN orders o ON o.user_id = u.id;

CROSS JOIN — every pair / CROSS JOIN — គ្រប់គូ

SELECT size, color FROM sizes CROSS JOIN colors;

GROUP BY & HAVING / GROUP BY និង HAVING

Group and count / ដាក់ក្រុម និងរាប់

SELECT country, COUNT(*) AS total
FROM users
GROUP BY country;

Filter groups with HAVING / តម្រងក្រុមជាមួយ HAVING

SELECT country, COUNT(*) AS total
FROM users
GROUP BY country
HAVING COUNT(*) > 100;

Group by with sum / ដាក់ក្រុមជាមួយផលបូក

SELECT customer_id, SUM(amount) AS spent
FROM orders
GROUP BY customer_id;

Aggregates / អនុគមន៍សរុប (Aggregates)

COUNT — number of rows / COUNT — ចំនួនជួរ

SELECT COUNT(*) FROM orders;

SUM — total / SUM — សរុប

SELECT SUM(amount) FROM orders;

AVG — average / AVG — មធ្យម

SELECT AVG(price) FROM products;

MIN / MAX / MIN / MAX — តិចបំផុត / ច្រើនបំផុត

SELECT MIN(price), MAX(price) FROM products;

Modifying data / កែប្រែទិន្នន័យ

INSERT a row / បញ្ចូលជួរដេក

INSERT INTO users (name, email)
VALUES ('Sok', 'sok@example.com');

INSERT multiple rows / បញ្ចូលច្រើនជួរ

INSERT INTO users (name, email) VALUES
  ('Sok', 'sok@example.com'),
  ('Dara', 'dara@example.com');

UPDATE rows / កែប្រែជួរដេក

UPDATE users SET country = 'KH' WHERE id = 1;

DELETE rows / លុបជួរដេក

DELETE FROM users WHERE id = 1;

Delete all rows (keep table) / លុបជួរទាំងអស់ (រក្សាតារាង)

DELETE FROM users;

CREATE TABLE / បង្កើតតារាង

Basic table with constraints / តារាងមូលដ្ឋានជាមួយកំហិត

CREATE TABLE users (
  id INTEGER PRIMARY KEY,
  name TEXT NOT NULL,
  email TEXT UNIQUE,
  age INTEGER DEFAULT 0
);

Foreign key / សោបរទេស (Foreign key)

CREATE TABLE orders (
  id INTEGER PRIMARY KEY,
  user_id INTEGER REFERENCES users(id),
  amount NUMERIC NOT NULL
);

Drop a table / លុបតារាង

DROP TABLE orders;

Indexes / លិបិក្រម (Index)

Create an index / បង្កើតលិបិក្រម

CREATE INDEX idx_users_email ON users (email);

Unique index / លិបិក្រមតែមួយគត់

CREATE UNIQUE INDEX idx_users_email ON users (email);

Drop an index / លុបលិបិក្រម

DROP INDEX idx_users_email;

Index tip / គន្លឹះសម្រាប់លិបិក្រម

-- Index columns used often in WHERE / JOIN
-- to speed up lookups.
SELECT * FROM users WHERE email = 'x@y.com';

Curated reference of standard SQL — dialect details (e.g. MySQL, PostgreSQL, SQLite) may differ; check your database documentation. / ជាសន្លឹកយោងដកស្រង់ SQL ស្ដង់ដារ — ព័ត៌មានលម្អិតតាមប្រភេទមូលដ្ឋានទិន្នន័យ (ឧ. MySQL, PostgreSQL, SQLite) អាចខុសគ្នា; សូមពិនិត្យឯកសាររបស់មូលដ្ឋានទិន្នន័យអ្នក។

Loading…

Frequently asked questions / សំណួរដែលសួរញឹកញាប់

A reference of core SQL: SELECT, JOINs, grouping, aggregates, CRUD, and table creation with examples. / ឯកសារយោង SQL មូលដ្ឋាន៖ SELECT, JOIN, grouping, aggregates, CRUD និងការបង្កើតតារាង ជាមួយឧទាហរណ៍។

Next recommended tools / ឧបករណ៍ណែនាំបន្ទាប់

Git Cheat Sheet — សន្លឹកយោង GitShares a category or workflow / មានប្រភេទ ឬលំហូរការងារដូចគ្នា HTML & CSS Cheat Sheet — សន្លឹកយោង HTML និង CSSShares a category or workflow / មានប្រភេទ ឬលំហូរការងារដូចគ្នា Linux Command Cheat Sheet — សន្លឹកយោង LinuxShares a category or workflow / មានប្រភេទ ឬលំហូរការងារដូចគ្នា SQL Formatter — រៀបចំទម្រង់ SQLShares a category or workflow / មានប្រភេទ ឬលំហូរការងារដូចគ្នា Markdown Cheat Sheet — សន្លឹកយោង MarkdownShares a category or workflow / មានប្រភេទ ឬលំហូរការងារដូចគ្នា Country Dialing Codes — លេខកូដទូរស័ព្ទអន្តរជាតិShares a category or workflow / មានប្រភេទ ឬលំហូរការងារដូចគ្នា