CASE - Popular snippets
- MySQL 8.0 CREATE TABLE INSERT INTO WITH SELECT WHERE CONCAT INNER JOIN CASE NOT ORDER BY BETWEEN AND LEFT JOIN
last run:
2025-01-13 10:42:44
127
- MS SQL Server 2019 AND NOT BETWEEN IN OR WITH ORDER BY CREATE TABLE INSERT INTO SELECT COUNT ROW_NUMBER JOIN INNER JOIN WHERE RIGHT SUM LAG LIKE COALESCE CASE TRUNCATE GROUP BY
last run:
2025-01-10 00:36:21
81
- PostgreSQL 14 WITH SELECT CASE IN ORDER BY SUM NOT
last run:
2024-11-29 07:47:15
39
- PostgreSQL 14 WITH SELECT CASE IN ORDER BY SUM NOT
last run:
2024-10-15 20:57:55
33
- PostgreSQL 15 CREATE TABLE INSERT INTO MONTH WITH SELECT JOIN SUBSTRING UPDATE CASE AND IN WHERE COUNT NOT
last run:
2024-12-04 12:38:44
30
- Oracle Database 21c WITH SELECT CASE GROUP BY ORDER BY
last run:
2023-11-17 16:03:12
25
- PostgreSQL 12 SELECT CONCAT CASE
last run:
2022-10-11 05:46:29
25
- MySQL 5.7 CREATE TABLE INSERT INTO SELECT CASE SUM WHERE GROUP BY
last run:
2021-11-10 15:41:49
24
- PostgreSQL 14 WITH SELECT CASE IN ORDER BY SUM NOT
last run:
2023-05-24 10:19:03
23
- MySQL 8.0 Sakila (ReadOnly) WITH SELECT SUM JOIN GROUP BY CASE AND NOT
last run:
2024-05-16 13:32:11
19
CASE - New snippets
-
Oracle Database 21c CREATE TABLE PRIMARY KEY NOT IN INSERT INTO SELECT SUM CASE BETWEEN AND JOIN GROUP BY ORDER BY
added at:
2025-01-22 15:01:29
1
-
Oracle Database 21c CREATE TABLE PRIMARY KEY NOT IN INSERT INTO SELECT SUM JOIN GROUP BY ORDER BY LEFT AND WHERE CASE BETWEEN HAVING
added at:
2025-01-22 14:07:32
1
-
Oracle Database 21c CREATE TABLE PRIMARY KEY NOT IN INSERT INTO SELECT SUM CASE BETWEEN AND JOIN GROUP BY ORDER BY WHERE HAVING LEFT
added at:
2025-01-22 14:06:43
1
-
MySQL 8.0 Sakila (ReadOnly) SELECT JOIN WHERE AND ORDER BY CASE SHOW LIKE
added at:
2025-01-22 12:40:18
1
-
MySQL 8.0 Sakila (ReadOnly) SELECT JOIN WHERE AND ORDER BY CASE
added at:
2025-01-22 12:40:13
2
-
MySQL 8.0 Sakila (ReadOnly) SELECT JOIN WHERE AND ORDER BY CASE SHOW LIKE
added at:
2025-01-22 12:37:38
2
-
MySQL 8.0 Sakila (ReadOnly) SELECT JOIN WHERE AND ORDER BY CASE
added at:
2025-01-22 12:37:32
2
-
MySQL 8.0 Sakila (ReadOnly) SELECT JOIN RIGHT WHERE AND ORDER BY CASE SHOW LIKE
added at:
2025-01-22 10:59:11
1
-
MySQL 8.0 Sakila (ReadOnly) SELECT JOIN WHERE LIKE AND ORDER BY CASE SHOW
added at:
2025-01-22 10:58:47
1
-
MySQL 8.0 Sakila (ReadOnly) SELECT JOIN RIGHT WHERE AND ORDER BY CASE SHOW LIKE
added at:
2025-01-22 10:58:39
1