CASE - Popular snippets
- 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
- 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:
2023-01-15 00:10:45
22
- 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
- MySQL 5.7 CREATE TABLE NOT AUTO_INCREMENT DELETE DEFAULT PRIMARY KEY INSERT INTO SELECT COUNT SUM INNER JOIN WHERE GROUP BY CASE IN ORDER BY
last run:
2022-09-15 13:24:12
15
- PostgreSQL 15 CREATE TABLE PRIMARY KEY NOT INSERT INTO WITH SELECT CASE LEAD ORDER BY OR WHERE JOIN AND BETWEEN
last run:
2022-09-04 17:11:56
13
- PostgreSQL 14 WITH SELECT ROW_NUMBER ORDER BY CASE
last run:
2022-08-16 07:20:10
13
- MySQL 8.0 CREATE TABLE INSERT INTO SELECT CASE ROW_NUMBER LEFT JOIN AND WHERE
last run:
2022-10-24 13:56:55
12
- PostgreSQL 14 SELECT CREATE TABLE ORDER BY CASE IN SUM BETWEEN AND
last run:
2022-10-11 12:24:14
11
- PostgreSQL 13 WITH SELECT ORDER BY CASE
last run:
2022-10-31 11:44:42
10
CASE - New snippets
-
MS SQL Server 2017 CREATE FUNCTION SELECT SUBSTRING CASE NOT DROP TABLE CREATE TABLE REPLACE LEFT JOIN WITH ORDER BY WHERE GROUP BY
added at:
2023-02-07 19:26:41
1
-
MySQL 5.7 SELECT ROW_NUMBER ORDER BY CASE COALESCE WHERE JOIN
added at:
2023-02-07 14:50:00
2
-
PostgreSQL 11 CREATE TABLE PRIMARY KEY NOT CONSTRAINT FOREIGN KEY INSERT INTO WITH SELECT JOIN WHERE GROUP BY ORDER BY COUNT CASE
added at:
2023-02-05 13:32:31
1
-
PostgreSQL 11 CREATE TABLE PRIMARY KEY NOT CONSTRAINT FOREIGN KEY INSERT INTO WITH SELECT JOIN WHERE GROUP BY ORDER BY COUNT CASE
added at:
2023-02-05 13:32:17
1
-
PostgreSQL 11 CREATE TABLE PRIMARY KEY NOT CONSTRAINT FOREIGN KEY INSERT INTO WITH SELECT JOIN WHERE GROUP BY ORDER BY COUNT CASE
added at:
2023-02-05 13:31:57
1
-
PostgreSQL 11 CREATE TABLE PRIMARY KEY NOT CONSTRAINT FOREIGN KEY INSERT INTO WITH SELECT JOIN WHERE GROUP BY ORDER BY AND COUNT CASE
added at:
2023-02-05 13:31:15
1
-
PostgreSQL 11 CREATE TABLE PRIMARY KEY NOT CONSTRAINT FOREIGN KEY INSERT INTO WITH SELECT JOIN WHERE GROUP BY ORDER BY COUNT CASE
added at:
2023-02-05 13:31:02
1
-
PostgreSQL 11 CREATE TABLE PRIMARY KEY NOT CONSTRAINT FOREIGN KEY INSERT INTO WITH SELECT JOIN WHERE GROUP BY ORDER BY COUNT CASE
added at:
2023-02-05 13:30:29
1
-
PostgreSQL 11 CREATE TABLE PRIMARY KEY NOT CONSTRAINT FOREIGN KEY INSERT INTO SELECT JOIN WHERE GROUP BY ORDER BY COUNT CASE
added at:
2023-02-05 13:27:29
1
-
PostgreSQL 11 CREATE TABLE PRIMARY KEY NOT CONSTRAINT FOREIGN KEY INSERT INTO SELECT ORDER BY JOIN WHERE GROUP BY COUNT CASE
added at:
2023-02-05 13:26:53
1