MySQL

SQL01 · MySQL

SELECT All Columns

SELECT All Columns — interactive SQL visualizer on sample tables with step-by-step explanation.

Beginner Login Open →

SQL02 · MySQL

SELECT Specific Columns

SELECT Specific Columns — interactive SQL visualizer on sample tables with step-by-step explanation.

Beginner Login Open →

SQL03 · MySQL

Column Aliases (AS)

Column Aliases (AS) — interactive SQL visualizer on sample tables with step-by-step explanation.

Beginner Login Open →

SQL04 · MySQL

DISTINCT

DISTINCT — interactive SQL visualizer on sample tables with step-by-step explanation.

Beginner Login Open →

SQL05 · MySQL

WHERE Filter

WHERE Filter — interactive SQL visualizer on sample tables with step-by-step explanation.

Beginner Login Open →

SQL06 · MySQL

ORDER BY

ORDER BY — interactive SQL visualizer on sample tables with step-by-step explanation.

Beginner Login Open →

SQL07 · MySQL

LIMIT

LIMIT — interactive SQL visualizer on sample tables with step-by-step explanation.

Beginner Login Open →

SQL08 · MySQL

LIMIT with OFFSET

LIMIT with OFFSET — interactive SQL visualizer on sample tables with step-by-step explanation.

Beginner Login Open →

SQL09 · MySQL

Computed Columns

Computed Columns — interactive SQL visualizer on sample tables with step-by-step explanation.

Beginner Login Open →

SQL10 · MySQL

CONCAT Strings

CONCAT Strings — interactive SQL visualizer on sample tables with step-by-step explanation.

Beginner Login Open →

SQL11 · MySQL

AND Operator

AND Operator — interactive SQL visualizer on sample tables with step-by-step explanation.

Beginner Login Open →

SQL12 · MySQL

OR Operator

OR Operator — interactive SQL visualizer on sample tables with step-by-step explanation.

Beginner Login Open →

SQL13 · MySQL

NOT Operator

NOT Operator — interactive SQL visualizer on sample tables with step-by-step explanation.

Beginner Login Open →

SQL14 · MySQL

BETWEEN

BETWEEN — interactive SQL visualizer on sample tables with step-by-step explanation.

Beginner Login Open →

SQL15 · MySQL

IN List

IN List — interactive SQL visualizer on sample tables with step-by-step explanation.

Beginner Login Open →

SQL16 · MySQL

NOT IN

NOT IN — interactive SQL visualizer on sample tables with step-by-step explanation.

Beginner Login Open →

SQL17 · MySQL

LIKE with %

LIKE with % — interactive SQL visualizer on sample tables with step-by-step explanation.

Beginner Login Open →

SQL18 · MySQL

LIKE with _

LIKE with _ — interactive SQL visualizer on sample tables with step-by-step explanation.

Beginner Login Open →

SQL19 · MySQL

IS NULL

IS NULL — interactive SQL visualizer on sample tables with step-by-step explanation.

Beginner Login Open →

SQL20 · MySQL

IS NOT NULL

IS NOT NULL — interactive SQL visualizer on sample tables with step-by-step explanation.

Beginner Login Open →

SQL21 · MySQL

Comparison Operators

Comparison Operators — interactive SQL visualizer on sample tables with step-by-step explanation.

Beginner Login Open →

SQL22 · MySQL

Grouping Conditions

Grouping Conditions — interactive SQL visualizer on sample tables with step-by-step explanation.

Beginner Login Open →

SQL23 · MySQL

COUNT(*)

COUNT(*) — interactive SQL visualizer on sample tables with step-by-step explanation.

Intermediate Login Open →

SQL24 · MySQL

SUM

SUM — interactive SQL visualizer on sample tables with step-by-step explanation.

Intermediate Login Open →

SQL25 · MySQL

AVG

AVG — interactive SQL visualizer on sample tables with step-by-step explanation.

Intermediate Login Open →

SQL26 · MySQL

MIN

MIN — interactive SQL visualizer on sample tables with step-by-step explanation.

Intermediate Login Open →

SQL27 · MySQL

MAX

MAX — interactive SQL visualizer on sample tables with step-by-step explanation.

Intermediate Login Open →

SQL28 · MySQL

GROUP BY

GROUP BY — interactive SQL visualizer on sample tables with step-by-step explanation.

Intermediate Login Open →

SQL29 · MySQL

GROUP BY Multiple Columns

GROUP BY Multiple Columns — interactive SQL visualizer on sample tables with step-by-step explanation.

Intermediate Login Open →

SQL30 · MySQL

HAVING

HAVING — interactive SQL visualizer on sample tables with step-by-step explanation.

Intermediate Login Open →

SQL31 · MySQL

GROUP_CONCAT

GROUP_CONCAT — interactive SQL visualizer on sample tables with step-by-step explanation.

Intermediate Login Open →

SQL32 · MySQL

COUNT DISTINCT

COUNT DISTINCT — interactive SQL visualizer on sample tables with step-by-step explanation.

Intermediate Login Open →

SQL33 · MySQL

INNER JOIN

INNER JOIN — interactive SQL visualizer on sample tables with step-by-step explanation.

Beginner Login Open →

SQL34 · MySQL

LEFT JOIN

LEFT JOIN — interactive SQL visualizer on sample tables with step-by-step explanation.

Beginner Login Open →

SQL35 · MySQL

RIGHT JOIN

RIGHT JOIN — interactive SQL visualizer on sample tables with step-by-step explanation.

Beginner Login Open →

SQL36 · MySQL

FULL OUTER JOIN

FULL OUTER JOIN — interactive SQL visualizer on sample tables with step-by-step explanation.

Beginner Login Open →

SQL37 · MySQL

CROSS JOIN

CROSS JOIN — interactive SQL visualizer on sample tables with step-by-step explanation.

Beginner Login Open →

SQL38 · MySQL

SELF JOIN

SELF JOIN — interactive SQL visualizer on sample tables with step-by-step explanation.

Beginner Login Open →

SQL39 · MySQL

JOIN with WHERE

JOIN with WHERE — interactive SQL visualizer on sample tables with step-by-step explanation.

Beginner Login Open →

SQL40 · MySQL

Join Three Tables

Join Three Tables — interactive SQL visualizer on sample tables with step-by-step explanation.

Beginner Login Open →

SQL41 · MySQL

NATURAL JOIN

NATURAL JOIN — interactive SQL visualizer on sample tables with step-by-step explanation.

Beginner Login Open →

SQL42 · MySQL

JOIN vs Subquery

JOIN vs Subquery — interactive SQL visualizer on sample tables with step-by-step explanation.

Beginner Login Open →

SQL43 · MySQL

Subquery in WHERE

Subquery in WHERE — interactive SQL visualizer on sample tables with step-by-step explanation.

Intermediate Login Open →

SQL44 · MySQL

Subquery with IN

Subquery with IN — interactive SQL visualizer on sample tables with step-by-step explanation.

Intermediate Login Open →

SQL45 · MySQL

Correlated Subquery

Correlated Subquery — interactive SQL visualizer on sample tables with step-by-step explanation.

Intermediate Login Open →

SQL46 · MySQL

Derived Table (Subquery in FROM)

Derived Table (Subquery in FROM) — interactive SQL visualizer on sample tables with step-by-step explanation.

Intermediate Login Open →

SQL47 · MySQL

EXISTS

EXISTS — interactive SQL visualizer on sample tables with step-by-step explanation.

Intermediate Login Open →

SQL48 · MySQL

NOT EXISTS

NOT EXISTS — interactive SQL visualizer on sample tables with step-by-step explanation.

Intermediate Login Open →

SQL49 · MySQL

ANY / SOME

ANY / SOME — interactive SQL visualizer on sample tables with step-by-step explanation.

Intermediate Login Open →

SQL50 · MySQL

ALL

ALL — interactive SQL visualizer on sample tables with step-by-step explanation.

Intermediate Login Open →

SQL51 · MySQL

UNION

UNION — interactive SQL visualizer on sample tables with step-by-step explanation.

Intermediate Login Open →

SQL52 · MySQL

UNION ALL

UNION ALL — interactive SQL visualizer on sample tables with step-by-step explanation.

Intermediate Login Open →

SQL53 · MySQL

INTERSECT

INTERSECT — interactive SQL visualizer on sample tables with step-by-step explanation.

Intermediate Login Open →

SQL54 · MySQL

EXCEPT / MINUS

EXCEPT / MINUS — interactive SQL visualizer on sample tables with step-by-step explanation.

Intermediate Login Open →

SQL55 · MySQL

UPPER and LOWER

UPPER and LOWER — interactive SQL visualizer on sample tables with step-by-step explanation.

Intermediate Login Open →

SQL56 · MySQL

LENGTH / CHAR_LENGTH

LENGTH / CHAR_LENGTH — interactive SQL visualizer on sample tables with step-by-step explanation.

Intermediate Login Open →

SQL57 · MySQL

SUBSTRING

SUBSTRING — interactive SQL visualizer on sample tables with step-by-step explanation.

Intermediate Login Open →

SQL58 · MySQL

CONCAT_WS

CONCAT_WS — interactive SQL visualizer on sample tables with step-by-step explanation.

Intermediate Login Open →

SQL59 · MySQL

REPLACE

REPLACE — interactive SQL visualizer on sample tables with step-by-step explanation.

Intermediate Login Open →

SQL60 · MySQL

TRIM

TRIM — interactive SQL visualizer on sample tables with step-by-step explanation.

Intermediate Login Open →

SQL61 · MySQL

LEFT and RIGHT

LEFT and RIGHT — interactive SQL visualizer on sample tables with step-by-step explanation.

Intermediate Login Open →

SQL62 · MySQL

LOCATE / INSTR

LOCATE / INSTR — interactive SQL visualizer on sample tables with step-by-step explanation.

Intermediate Login Open →

SQL63 · MySQL

ROUND

ROUND — interactive SQL visualizer on sample tables with step-by-step explanation.

Intermediate Login Open →

SQL64 · MySQL

CEIL and FLOOR

CEIL and FLOOR — interactive SQL visualizer on sample tables with step-by-step explanation.

Intermediate Login Open →

SQL65 · MySQL

MOD

MOD — interactive SQL visualizer on sample tables with step-by-step explanation.

Intermediate Login Open →

SQL66 · MySQL

ABS and POWER

ABS and POWER — interactive SQL visualizer on sample tables with step-by-step explanation.

Intermediate Login Open →

SQL67 · MySQL

NOW and CURDATE

NOW and CURDATE — interactive SQL visualizer on sample tables with step-by-step explanation.

Intermediate Login Open →

SQL68 · MySQL

DATEDIFF

DATEDIFF — interactive SQL visualizer on sample tables with step-by-step explanation.

Intermediate Login Open →

SQL69 · MySQL

DATE_FORMAT

DATE_FORMAT — interactive SQL visualizer on sample tables with step-by-step explanation.

Intermediate Login Open →

SQL70 · MySQL

YEAR MONTH DAY

YEAR MONTH DAY — interactive SQL visualizer on sample tables with step-by-step explanation.

Intermediate Login Open →

SQL71 · MySQL

CASE WHEN

CASE WHEN — interactive SQL visualizer on sample tables with step-by-step explanation.

Intermediate Login Open →

SQL72 · MySQL

IF Function

IF Function — interactive SQL visualizer on sample tables with step-by-step explanation.

Intermediate Login Open →

SQL73 · MySQL

IFNULL / COALESCE

IFNULL / COALESCE — interactive SQL visualizer on sample tables with step-by-step explanation.

Intermediate Login Open →

SQL74 · MySQL

NULLIF

NULLIF — interactive SQL visualizer on sample tables with step-by-step explanation.

Intermediate Login Open →

SQL75 · MySQL

INSERT Row

INSERT Row — interactive SQL visualizer on sample tables with step-by-step explanation.

Intermediate Login Open →

SQL76 · MySQL

INSERT Multiple Rows

INSERT Multiple Rows — interactive SQL visualizer on sample tables with step-by-step explanation.

Intermediate Login Open →

SQL77 · MySQL

UPDATE Rows

UPDATE Rows — interactive SQL visualizer on sample tables with step-by-step explanation.

Intermediate Login Open →

SQL78 · MySQL

UPDATE Single Row

UPDATE Single Row — interactive SQL visualizer on sample tables with step-by-step explanation.

Intermediate Login Open →

SQL79 · MySQL

DELETE Rows

DELETE Rows — interactive SQL visualizer on sample tables with step-by-step explanation.

Intermediate Login Open →

SQL80 · MySQL

INSERT ON DUPLICATE (Upsert)

INSERT ON DUPLICATE (Upsert) — interactive SQL visualizer on sample tables with step-by-step explanation.

Intermediate Login Open →

SQL81 · MySQL

CREATE TABLE

CREATE TABLE — interactive SQL visualizer on sample tables with step-by-step explanation.

Intermediate Login Open →

SQL82 · MySQL

MySQL Data Types

MySQL Data Types — interactive SQL visualizer on sample tables with step-by-step explanation.

Intermediate Login Open →

SQL83 · MySQL

ALTER TABLE ADD Column

ALTER TABLE ADD Column — interactive SQL visualizer on sample tables with step-by-step explanation.

Advanced Login Open →

SQL84 · MySQL

ALTER TABLE MODIFY/DROP

ALTER TABLE MODIFY/DROP — interactive SQL visualizer on sample tables with step-by-step explanation.

Advanced Login Open →

SQL85 · MySQL

DROP TABLE

DROP TABLE — interactive SQL visualizer on sample tables with step-by-step explanation.

Advanced Login Open →

SQL86 · MySQL

TRUNCATE

TRUNCATE — interactive SQL visualizer on sample tables with step-by-step explanation.

Advanced Login Open →

SQL87 · MySQL

CREATE DATABASE

CREATE DATABASE — interactive SQL visualizer on sample tables with step-by-step explanation.

Advanced Login Open →

SQL88 · MySQL

RENAME TABLE

RENAME TABLE — interactive SQL visualizer on sample tables with step-by-step explanation.

Advanced Login Open →

SQL89 · MySQL

PRIMARY KEY

PRIMARY KEY — interactive SQL visualizer on sample tables with step-by-step explanation.

Advanced Login Open →

SQL90 · MySQL

FOREIGN KEY

FOREIGN KEY — interactive SQL visualizer on sample tables with step-by-step explanation.

Advanced Login Open →

SQL91 · MySQL

UNIQUE Constraint

UNIQUE Constraint — interactive SQL visualizer on sample tables with step-by-step explanation.

Advanced Login Open →

SQL92 · MySQL

NOT NULL Constraint

NOT NULL Constraint — interactive SQL visualizer on sample tables with step-by-step explanation.

Advanced Login Open →

SQL93 · MySQL

DEFAULT Value

DEFAULT Value — interactive SQL visualizer on sample tables with step-by-step explanation.

Advanced Login Open →

SQL94 · MySQL

AUTO_INCREMENT and CHECK

AUTO_INCREMENT and CHECK — interactive SQL visualizer on sample tables with step-by-step explanation.

Advanced Login Open →

SQL95 · MySQL

INDEX

INDEX — interactive SQL visualizer on sample tables with step-by-step explanation.

Advanced Login Open →

SQL96 · MySQL

VIEW

VIEW — interactive SQL visualizer on sample tables with step-by-step explanation.

Advanced Login Open →

SQL97 · MySQL

Transactions (COMMIT/ROLLBACK)

Transactions (COMMIT/ROLLBACK) — interactive SQL visualizer on sample tables with step-by-step explanation.

Advanced Login Open →

SQL98 · MySQL

Normalization (1NF-3NF)

Normalization (1NF-3NF) — interactive SQL visualizer on sample tables with step-by-step explanation.

Advanced Login Open →

SQL99 · MySQL

Window Functions (RANK)

Window Functions (RANK) — interactive SQL visualizer on sample tables with step-by-step explanation.

Advanced Login Open →