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

JSON_ARRAY - Popular snippets

MariaDB 11.5 SELECT JSON_ARRAY last run: 2025-03-26 08:34:51
17
MySQL 8.0 CREATE TABLE INSERT INTO SELECT JOIN REPLACE JSON_ARRAY last run: 2024-10-11 03:17:36
16
MySQL 8.0 CREATE TABLE NOT AUTO_INCREMENT PRIMARY KEY DEFAULT INSERT INTO CONSTRAINT FOREIGN KEY DELETE UPDATE WITH SELECT COUNT JOIN GROUP BY ORDER BY JSON_ARRAY SUM WHERE AND last run: 2024-02-01 17:49:01
11
CREATE TABLE INSERT INTO SELECT JSON_ARRAY JOIN GROUP BY ORDER BY last run: 2023-12-05 19:31:51
9
PostgreSQL 14 CREATE TABLE INSERT INTO SELECT JSON_ARRAY last run: 2022-10-24 19:35:17
8
CREATE TABLE INSERT INTO SELECT JOIN JSON_CONTAINS JSON_ARRAY last run: 2024-08-30 03:25:05
8
MySQL 8.0 Sakila (ReadOnly) SELECT JSON_ARRAY COUNT JOIN GROUP BY last run: 2025-02-05 22:50:27
6
MySQL 8.0 CREATE TABLE NOT DEFAULT INSERT INTO ALTER TABLE PRIMARY KEY AUTO_INCREMENT SELECT COUNT JSON_ARRAY JOIN GROUP BY last run: 2025-03-05 08:57:58
6
MySQL 8.0 Sakila (ReadOnly) WITH SELECT COUNT JOIN GROUP BY JSON_ARRAY last run: 2024-06-28 12:21:26
6
MySQL 8.0 Sakila (ReadOnly) SELECT JSON_ARRAY JOIN GROUP BY last run: 2024-06-22 17:09:58
6

JSON_ARRAY - New snippets

MySQL 8.0 Sakila (ReadOnly) SELECT JSON_ARRAY GROUP BY added at: 2025-04-25 06:11:15
1
MySQL 8.0 Sakila (ReadOnly) SELECT JSON_ARRAY COUNT JOIN GROUP BY added at: 2025-04-21 09:22:03
1
MySQL 8.0 Sakila (ReadOnly) SELECT JSON_ARRAY JOIN ORDER BY SHOW LIKE added at: 2025-04-19 11:41:37
1
MySQL 8.0 Sakila (ReadOnly) SELECT JSON_ARRAY COUNT LEFT JOIN GROUP BY SHOW LIKE added at: 2025-04-19 11:41:06
1
MySQL 8.0 Sakila (ReadOnly) SELECT JSON_ARRAY COUNT LEFT JOIN GROUP BY SHOW LIKE added at: 2025-04-19 11:40:43
1
MySQL 8.0 Sakila (ReadOnly) SELECT JSON_ARRAY COUNT LEFT JOIN GROUP BY SHOW LIKE added at: 2025-04-19 11:40:05
1
MySQL 8.0 Sakila (ReadOnly) SELECT JSON_ARRAY COUNT LEFT JOIN GROUP BY SHOW LIKE added at: 2025-04-19 11:39:45
1
MySQL 8.0 Sakila (ReadOnly) SELECT JSON_ARRAY COUNT JOIN GROUP BY SHOW LIKE added at: 2025-04-19 11:38:34
1
MySQL 8.0 Sakila (ReadOnly) SELECT JSON_ARRAY COUNT JOIN GROUP BY SHOW LIKE added at: 2025-04-19 11:38:10
1
MySQL 8.0 Sakila (ReadOnly) SELECT JSON_ARRAY COUNT JOIN GROUP BY SHOW LIKE added at: 2025-04-17 23:02:23
1

SQLize.online - Popular functions

SELECT

1478k

WHERE

812k

ORDER BY

661k

CREATE TABLE

478k

JOIN

467k

INSERT INTO

426k

GROUP BY

392k

AND

357k

325k

PRIMARY KEY

308k

NOT

307k

COUNT

281k

SHOW

255k

WITH

160k

FOREIGN KEY

149k

LEFT

138k

CONSTRAINT

130k

DROP TABLE

115k

AUTO_INCREMENT

111k

INNER JOIN

110k

LENGTH

103k

99k

SUM

99k

DEFAULT

87k

HAVING

82k

UPDATE

68k

57k

BETWEEN

54k

CONCAT

43k

DELETE

41k

CASE

36k

CREATE VIEW

36k

ALTER TABLE

35k

DROP VIEW

27k

REPLACE

26k

ROW_NUMBER

24k

MONTH

24k

CREATE PROCEDURE

23k

EXEC

19k

DROP PROCEDURE

19k

RIGHT

17k

DENSE_RANK

12k

ADD CONSTRAINT

12k

COALESCE

11k

LEAD

11k

LAG

10k

SUBSTRING

10k

CROSS JOIN

OUTER JOIN

CREATE OR REPLACE FUNCTION

INSERT INTO

CREATE FUNCTION

TRUNCATE

ADD COLUMN

DAYOFWEEK

UPPER

SUBSTR

LOWER

DROP COLUMN

DESCRIBE

TRIM

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

750

NULLIF

696

JSON_AGG

640

UUID_GENERATE_V4

624

INNER JOIN

516

INSERT INTO

437

CREATE OR REPLACE TRIGGER

435

GROUP BY

416

ADD CONSTRAINT

403

RTRIM

396

DROP FUNCTION

360

RPAD

262

LTRIM

222

DROP TRIGGER

192

FOREIGN KEY

178

DROP INDEX

176

PRIMARY KEY

153

ROW_TO_JSON

138

CREATE TABLE

132

DROP SEQUENCE

DROP PROCEDURE

ADD COLUMN

INNER JOIN

ADD CONSTRAINT

CREATE OR REPLACE FUNCTION

DROP TABLE

INSERT INTO

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

JSON_ARRAY - Popular snippets

JSON_ARRAY - New snippets

SQLize.online - Popular functions