SQL Queries Calculator | AllScienceTools

SELECT column1, column2
FROM table_name
WHERE condition
ORDER BY column ASC|DESC;

INNER JOIN	Records with match in both tables
LEFT JOIN	All from Left, matched from Right
RIGHT JOIN	All from Right, matched from Left
FULL JOIN	Match in either table

SELECT * FROM A
INNER JOIN B ON A.id = B.a_id;

SELECT city, COUNT(*)
FROM users
GROUP BY city
HAVING COUNT(*) > 5;

INSERT INTO table (c1, c2)
VALUES (v1, v2);

UPDATE table
SET c1 = v1
WHERE condition;

DELETE FROM table
WHERE condition;

Preparing your Lab

AllScienceTools