SQLize - format run and share SQL queries online

Tags: MySQL 5.7 MySQL 5.7 (Sakila) MySQL 8.0 MySQL 8.0 (Sakila) MariaDB 10 MariaDB 10 (Sakila) SQLite 3 PostgreSQL 11 PostgreSQL 12 PostgreSQL 13 PostgreSQL 14 PostgreSQL 15 MS SQL Server 2017 MS SQL Server 2019 MS SQL Server 2022 Oracle Database 19c Oracle Database 19c (HR) Oracle Database 21c Oracle Database 23c Free

NULLIF - Popular snippets

MS SQL Server 2017 CREATE TABLE INSERT INTO SELECT LEFT JOIN CASE NULLIF REPLACE WHERE ORDER BY last run: 2022-12-03 21:00:52
16
PostgreSQL 14 NOT CREATE TABLE DEFAULT UUID_GENERATE_V4 PRIMARY KEY INSERT INTO UPDATE SELECT LAG ORDER BY LEFT JOIN WHERE COALESCE SUM AND GROUP BY NULLIF WITH last run: 2023-05-07 15:38:32
6
PostgreSQL 13 NOT CREATE TABLE DEFAULT UUID_GENERATE_V4 PRIMARY KEY INSERT INTO UPDATE SELECT LAG ORDER BY LEFT JOIN WHERE COALESCE SUM AND GROUP BY NULLIF WITH last run: 2023-05-07 22:39:09
3
PostgreSQL 13 NOT CREATE TABLE DEFAULT UUID_GENERATE_V4 PRIMARY KEY INSERT INTO UPDATE SELECT LAG ORDER BY LEFT JOIN WHERE COALESCE SUM AND GROUP BY NULLIF WITH last run: 2023-05-07 22:40:17
3
PostgreSQL 12 SELECT NULLIF last run: 2022-12-06 12:46:43
3
PostgreSQL 13 NOT CREATE TABLE DEFAULT UUID_GENERATE_V4 PRIMARY KEY INSERT INTO UPDATE SELECT LAG ORDER BY LEFT JOIN WHERE COALESCE SUM AND GROUP BY NULLIF WITH CASE last run: 2023-05-07 23:16:35
2
PostgreSQL 13 NOT CREATE TABLE DEFAULT UUID_GENERATE_V4 PRIMARY KEY INSERT INTO UPDATE SELECT LAG ORDER BY LEFT JOIN WHERE COALESCE SUM AND GROUP BY NULLIF WITH CASE last run: 2023-05-07 22:44:58
2
PostgreSQL 13 NOT CREATE TABLE DEFAULT UUID_GENERATE_V4 PRIMARY KEY INSERT INTO UPDATE SELECT LAG ORDER BY LEFT JOIN WHERE COALESCE SUM AND GROUP BY NULLIF WITH last run: 2023-05-07 22:38:53
2
PostgreSQL 13 NOT CREATE TABLE DEFAULT UUID_GENERATE_V4 PRIMARY KEY INSERT INTO UPDATE SELECT LAG ORDER BY LEFT JOIN WHERE COALESCE SUM AND GROUP BY NULLIF WITH last run: 2023-05-07 21:37:03
2
PostgreSQL 13 NOT CREATE TABLE DEFAULT UUID_GENERATE_V4 PRIMARY KEY INSERT INTO UPDATE SELECT LAG ORDER BY LEFT JOIN WHERE COALESCE SUM AND GROUP BY NULLIF WITH last run: 2023-05-07 21:36:23
2

NULLIF - New snippets

Oracle Database 21c SELECT COUNT WHERE AND IN NULLIF added at: 2023-05-16 15:16:35
1
Oracle Database 21c CREATE PROCEDURE SELECT ORDER BY DELETE COUNT WHERE AND NULLIF OR LIKE NOT IN INSERT INTO added at: 2023-05-16 15:03:21
1
PostgreSQL 13 NOT CREATE TABLE DEFAULT UUID_GENERATE_V4 PRIMARY KEY INSERT INTO UPDATE SELECT LAG ORDER BY LEFT JOIN WHERE COALESCE SUM AND GROUP BY NULLIF WITH CASE added at: 2023-05-07 22:45:17
2
PostgreSQL 13 NOT CREATE TABLE DEFAULT UUID_GENERATE_V4 PRIMARY KEY INSERT INTO UPDATE SELECT LAG ORDER BY LEFT JOIN WHERE COALESCE SUM AND GROUP BY NULLIF WITH CASE added at: 2023-05-07 22:44:20
2
PostgreSQL 13 NOT CREATE TABLE DEFAULT UUID_GENERATE_V4 PRIMARY KEY INSERT INTO UPDATE SELECT LAG ORDER BY LEFT JOIN WHERE COALESCE SUM AND GROUP BY NULLIF WITH added at: 2023-05-07 22:39:49
1
PostgreSQL 13 NOT CREATE TABLE DEFAULT UUID_GENERATE_V4 PRIMARY KEY INSERT INTO UPDATE SELECT LAG ORDER BY LEFT JOIN WHERE COALESCE SUM AND GROUP BY NULLIF WITH added at: 2023-05-07 22:39:32
1
PostgreSQL 13 NOT CREATE TABLE DEFAULT UUID_GENERATE_V4 PRIMARY KEY INSERT INTO UPDATE SELECT LAG ORDER BY LEFT JOIN WHERE COALESCE SUM AND GROUP BY NULLIF WITH added at: 2023-05-07 22:38:58
1
PostgreSQL 13 NOT CREATE TABLE DEFAULT UUID_GENERATE_V4 PRIMARY KEY INSERT INTO UPDATE SELECT LAG ORDER BY LEFT JOIN WHERE COALESCE SUM AND GROUP BY NULLIF WITH added at: 2023-05-07 22:38:48
2
PostgreSQL 13 NOT CREATE TABLE DEFAULT UUID_GENERATE_V4 PRIMARY KEY INSERT INTO UPDATE SELECT LAG ORDER BY LEFT JOIN WHERE COALESCE SUM AND GROUP BY NULLIF WITH added at: 2023-05-07 22:38:10
1
PostgreSQL 13 NOT CREATE TABLE DEFAULT UUID_GENERATE_V4 PRIMARY KEY INSERT INTO UPDATE SELECT LAG ORDER BY LEFT JOIN WHERE COALESCE SUM AND GROUP BY NULLIF WITH added at: 2023-05-07 21:53:30
3

SQLize.online - Popular functions

CREATE TABLE

206k

SELECT

204k

INSERT INTO

187k

WHERE

125k

PRIMARY KEY

125k

NOT

109k

AND

64k

FOREIGN KEY

59k

CONSTRAINT

52k

JOIN

52k

GROUP BY

51k

ORDER BY

45k

COUNT

45k

AUTO_INCREMENT

44k

DROP TABLE

42k

DEFAULT

41k

WITH

37k

INNER JOIN

28k

LEFT

28k

UPDATE

26k

IN

23k

SUM

21k

DELETE

18k

CREATE VIEW

16k

ALTER TABLE

14k

LIKE

13k

DROP VIEW

12k

OR

12k

BETWEEN

12k

HAVING

11k

CASE

10k

CREATE PROCEDURE

9k

DROP PROCEDURE

8k

EXEC

7k

MONTH

7k

ROW_NUMBER

6k

RIGHT

5k

SHOW

5k

CONCAT

5k

LAG

4k

ADD CONSTRAINT

4k

CREATE OR REPLACE FUNCTION

3k

CREATE FUNCTION

3k

COALESCE

3k

OUTER JOIN

2k

LEAD

2k

INSERT INTO

2k

TRUNCATE

2k

ADD COLUMN

2k

DENSE_RANK

2k

CROSS JOIN

2k

UPPER

2k

LENGTH

2k

SUBSTRING

1k

TRIM

1k

REPLACE

1k

CREATE OR REPLACE VIEW

939

INSERT INTO

863

LOWER

834

DROP COLUMN

799

CREATE OR REPLACE PROCEDURE

780

DESCRIBE

674

SUBSTR

554

IFNULL

524

INSERT INTO

455

LEFT JOIN

413

REVERSE

388

JSON_CONTAINS

375

INNER JOIN

313

JSON_ARRAY

308

280

DROP CONSTRAINT

274

UUID_GENERATE_V4

262

DROP FUNCTION

243

INSERT INTO

226

CREATE OR REPLACE TRIGGER

194

NULLIF

172

PRIMARY KEY

138

JSON_AGG

137

ORDER BY

115

LTRIM

114

GROUP BY

105

DAYOFWEEK

93

LPAD

88

RTRIM

69

ADD COLUMN

51

INSERT INTO

48

DROP TRIGGER

48

46

CREATE OR REPLACE FUNCTION

46

DROP TABLE

38

CREATE TABLE

37

RPAD

37

DROP INDEX

34

DROP SEQUENCE

34

INSERT INTO

30

ROW_TO_JSON

26

CROSS JOIN

25

INSERT INTO

24

23

© 2023 SQLize - format run and share SQL queries online | About project | Disclaimer |

our telegram chat
PHP versions: PHP 5.6, PHP 7.4, PHP 8.0, PHP 8.1, PHP 8.2.3
RDBMS versions: MySQL 5.7, MySQL 5.7 (Sakila), MySQL 8.0, MySQL 8.0 (Sakila), MariaDB 10, MariaDB 10 (Sakila), SQLite 3, PostgreSQL 11, PostgreSQL 12, PostgreSQL 13, PostgreSQL 14, PostgreSQL 15, MS SQL Server 2017, MS SQL Server 2019, MS SQL Server 2022, Oracle Database 19c, Oracle Database 19c (HR), Oracle Database 21c, Oracle Database 23c Free