Tags: MySQL 5.7 MySQL 8.0 MariaDB 10 SQLite 3 PostgreSQL 11 PostgreSQL 12 PostgreSQL 13 PostgreSQL 14 MS SQL Server 2017 MS SQL Server 2019 Oracle Database 11c Oracle Database 19c Oracle Database 21c
Oracle Database 11c - Popular snippets
Oracle Database 11c - New snippets
SQLize.online - Popular functions
CREATE TABLE67k
SELECT 61k
INSERT INTO 60k
WHERE 34k
PRIMARY KEY 33k
NOT 24k
GROUP BY 16k
COUNT 16k
ORDER BY 16k
AND 15k
JOIN 14k
FOREIGN KEY 12k
UPDATE 10k
WITH 10k
AUTO_INCREMENT 8k
IN 8k
DELETE 8k
SUM 7k
LEFT 7k
INNER JOIN 6k
ALTER TABLE 6k
DEFAULT 5k
LIKE 5k
CONSTRAINT 5k
OR 4k
BETWEEN 4k
HAVING 3k
CASE 2k
SHOW 2k
ROW_NUMBER 2k
LAG 2k
CREATE VIEW 2k
MONTH 2k
CONCAT 2k
TRUNCATE 2k
DROP TABLE 1k
EXEC 1k
OUTER JOIN 1k
ADD COLUMN 973
RIGHT 922
CREATE FUNCTION 905
DENSE_RANK 904
COALESCE 900
TRIM 693
SUBSTRING 664
ADD CONSTRAINT 663
CROSS JOIN 659
LENGTH 605
LEAD 544
DROP COLUMN 522
REPLACE 436
CREATE OR REPLACE FUNCTION 415
UPPER 295
LOWER 290
LEFT JOIN 225
SUBSTR 203
CREATE PROCEDURE 189
REVERSE 179
DESCRIBE 176
ADD CONSTRAINT 132
INSERT
INTO 112
IFNULL 106
JSON_ARRAY 96
DROP CONSTRAINT 77
INSERT
INTO 59
JSON_AGG 54
RTRIM 52
ADD
COLUMN 50
ORDER BY 48
JSON_CONTAINS 47
ADD
CONSTRAINT 46
CREATE
OR REPLACE FUNCTION 46
LPAD 42
DROP
TABLE 30
INSERT
INTO 29
DROP VIEW 27
INSERT
INTO 24
DROP INDEX 24
CROSS JOIN 23
NULLIF 22
DROP PROCEDURE 21
CREATE OR REPLACE PROCEDURE 18
INSERT INTO 17
GROUP BY 17
CREATE OR REPLACE VIEW 14
ROW_TO_JSON 12
ORDER BY 12
DROP TRIGGER 12
CREATE
OR REPLACE FUNCTION 9
INNER
JOIN 9
LTRIM 8
DROP FUNCTION 8
FOREIGN KEY 8
GROUP BY 7
UUID_GENERATE_V4 7
CREATE TABLE 4
INSERT INTO 3
RIGTH JOIN 3
RANDOM() 2
CROSS
JOIN 2
© 2022 SQLize - format run and share SQL queries online |
About project |
Disclaimer
PHP versions: 5.6.40, 7.4.14, 8.0.1, 8.1.5 | RDBMS versions: MySQL 5.7.33, 8.0.23, MariaDB 10.5.9, PostgreSQL 11.9, 12.4, 13.2, 14.0, Microsoft SQL Server 2017, 2019, SQLite 3, Oracle 21c, 19c (with predefined tables)
PHP versions: 5.6.40, 7.4.14, 8.0.1, 8.1.5 | RDBMS versions: MySQL 5.7.33, 8.0.23, MariaDB 10.5.9, PostgreSQL 11.9, 12.4, 13.2, 14.0, Microsoft SQL Server 2017, 2019, SQLite 3, Oracle 21c, 19c (with predefined tables)