Run, Practice, Share: Your Interactive SQL Playground

Tags: MariaDB 11.4 MariaDB 11.5 MariaDB 10 MariaDB 10 Sakila (ReadOnly) MySQL 8.0 MySQL 8.0 Sakila (ReadOnly) SQLite 3 SQLite 3 Preloaded PostgreSQL 10 Bookings (ReadOnly) PostgreSQL 13 PostgreSQL 14 PostgreSQL 15 PostgreSQL 16 PostgreSQL 17 MS SQL Server 2017 MS SQL Server 2019 MS SQL Server 2022 MS SQL Server 2022 AdventureWorks (ReadOnly) Firebird 4.0 Firebird 4.0 (Employee) Oracle Database 19c (HR) Oracle Database 21c Oracle Database 23c Free SOQOL

SELECT - Popular snippets

SELECT VERSION() last run: 2025-01-31 15:44:21
4832
MySQL 8.0 Sakila (ReadOnly) SELECT last run: 2025-03-25 08:38:06
4652
MySQL 8.0 Sakila (ReadOnly) SELECT last run: 2025-03-25 06:24:27
3959
MySQL 8.0 Sakila (ReadOnly) SELECT SHOW LIKE last run: 2025-03-25 08:37:50
3884
MySQL 8.0 SELECT VERSION() last run: 2025-03-24 15:18:53
2256
MySQL 8.0 Sakila (ReadOnly) SELECT SHOW LIKE last run: 2025-03-25 08:04:56
2087
MySQL 8.0 Sakila (ReadOnly) SELECT last run: 2025-03-25 08:07:14
1968
MySQL 8.0 Sakila (ReadOnly) SELECT SHOW LIKE last run: 2025-03-25 08:07:21
1734
MySQL 8.0 Sakila (ReadOnly) SELECT SHOW LIKE last run: 2025-03-24 23:03:53
1696
MySQL 8.0 Sakila (ReadOnly) SELECT last run: 2025-03-25 07:00:01
1553

SELECT - New snippets

MySQL 8.0 CREATE TABLE PRIMARY KEY AUTO_INCREMENT DEFAULT INSERT INTO UPDATE WHERE SELECT added at: 2025-03-25 09:28:57
1
PostgreSQL 10 Bookings (ReadOnly) WITH SELECT WHERE LEFT SUBSTRING COUNT SUM GROUP BY added at: 2025-03-25 09:28:57
1
PostgreSQL 10 Bookings (ReadOnly) SELECT COUNT GROUP BY added at: 2025-03-25 09:28:54
1
PostgreSQL 10 Bookings (ReadOnly) WITH SELECT WHERE LEFT SUBSTRING COUNT SUM GROUP BY added at: 2025-03-25 09:28:42
1
PostgreSQL 10 Bookings (ReadOnly) SELECT COUNT JOIN AND added at: 2025-03-25 09:28:33
1
PostgreSQL 10 Bookings (ReadOnly) SELECT COUNT JOIN AND added at: 2025-03-25 09:28:18
1
MySQL 8.0 CREATE TABLE PRIMARY KEY INSERT INTO AUTO_INCREMENT DEFAULT SELECT added at: 2025-03-25 09:28:17
1
MySQL 8.0 CREATE TABLE PRIMARY KEY AUTO_INCREMENT DEFAULT INSERT INTO UPDATE WHERE SELECT added at: 2025-03-25 09:28:16
1
MySQL 8.0 CREATE TABLE INSERT INTO SELECT COUNT SUM GROUP BY ORDER BY added at: 2025-03-25 09:28:13
1
PostgreSQL 10 Bookings (ReadOnly) WITH SELECT WHERE LEFT SUBSTRING COUNT SUM GROUP BY added at: 2025-03-25 09:28:10
1

SQLize.online - Popular functions

SELECT

1363k

WHERE

746k

ORDER BY

603k

CREATE TABLE

457k

JOIN

430k

INSERT INTO

408k

GROUP BY

364k

AND

332k

297k

PRIMARY KEY

292k

NOT

287k

COUNT

263k

SHOW

233k

WITH

149k

FOREIGN KEY

141k

LEFT

127k

CONSTRAINT

122k

DROP TABLE

106k

INNER JOIN

105k

AUTO_INCREMENT

104k

LENGTH

95k

SUM

94k

93k

DEFAULT

82k

HAVING

77k

UPDATE

64k

52k

BETWEEN

51k

CONCAT

40k

DELETE

40k

CASE

35k

ALTER TABLE

33k

CREATE VIEW

33k

DROP VIEW

25k

REPLACE

24k

ROW_NUMBER

23k

MONTH

23k

CREATE PROCEDURE

21k

EXEC

19k

DROP PROCEDURE

18k

RIGHT

17k

ADD CONSTRAINT

11k

DENSE_RANK

11k

COALESCE

11k

LEAD

10k

LAG

SUBSTRING

CROSS JOIN

OUTER JOIN

CREATE OR REPLACE FUNCTION

INSERT INTO

CREATE FUNCTION

TRUNCATE

ADD COLUMN

DAYOFWEEK

UPPER

SUBSTR

LOWER

DROP COLUMN

TRIM

DESCRIBE

INSERT INTO

LEFT JOIN

IFNULL

CREATE OR REPLACE VIEW

CREATE OR REPLACE PROCEDURE

REVERSE

JSON_ARRAY

JSON_CONTAINS

LPAD

DROP CONSTRAINT

INSERT INTO

855

ORDER BY

702

NULLIF

657

UUID_GENERATE_V4

613

JSON_AGG

582

INNER JOIN

501

CREATE OR REPLACE TRIGGER

428

INSERT INTO

408

GROUP BY

407

ADD CONSTRAINT

402

DROP FUNCTION

344

RTRIM

341

RPAD

260

LTRIM

218

DROP TRIGGER

183

DROP INDEX

173

FOREIGN KEY

172

PRIMARY KEY

153

ROW_TO_JSON

136

DROP SEQUENCE

CREATE TABLE

DROP PROCEDURE

ADD COLUMN

ADD CONSTRAINT

CREATE OR REPLACE FUNCTION

DROP TABLE

INSERT INTO

INNER JOIN

Like the site? Share it!

Have a questions? Ask in our telegram chat!

PHP versions: PHP 7.4, PHP 8.0, PHP 8.1, PHP 8.2, PHP 8.3, PHP 8.4
RDBMS versions: MariaDB 11.4, MariaDB 11.5, MariaDB 10, MariaDB 10 Sakila (ReadOnly), MySQL 8.0, MySQL 8.0 Sakila (ReadOnly), SQLite 3, SQLite 3 Preloaded, PostgreSQL 10 Bookings (ReadOnly), PostgreSQL 13, PostgreSQL 14, PostgreSQL 15, PostgreSQL 16, PostgreSQL 17, MS SQL Server 2017, MS SQL Server 2019, MS SQL Server 2022, MS SQL Server 2022 AdventureWorks (ReadOnly), Firebird 4.0, Firebird 4.0 (Employee), Oracle Database 19c (HR), Oracle Database 21c, Oracle Database 23c Free, SOQOL

SQLize Online / PHPize Online / SQLtest Online

SELECT - Popular snippets

SELECT - New snippets

SQLize.online - Popular functions