会員登録（無料）で全機能が使える！
MAIN TOOLS
UTILITIES
INFO
Ultimate SQL Function Dictionary
CONCAT(a, b)
a || b
a + b
SUBSTRING(s,1,3)
SUBSTR(s,1,3)
CHAR_LENGTH(s)
LENGTH(s)
LEN(s)
LOCATE('a', s)
POSITION('a' in s)
INSTR(s, 'a')
CHARINDEX('a', s)
STRPOS(s, 'a')
NOW()
SYSDATE
GETDATE()
CURRENT_DATETIME()
DATE_SUB(NOW(), INTERVAL 1 DAY)
NOW() - INTERVAL '1 day'
SYSDATE - 1
DATEADD(day, -1, GETDATE())
DATE_SUB(CURRENT_DATE(), INTERVAL 1 DAY)
DATEDIFF(end, start)
end - start
DATEDIFF(day, start, end)
DATE_DIFF(end, start, DAY)
DATE_FORMAT(col, '%Y-%m-%d')
TO_CHAR(col, 'YYYY-MM-DD')
FORMAT(col, 'yyyy-MM-dd')
FORMAT_DATE('%Y-%m-%d', col)
IFNULL(col, 0)
COALESCE
COALESCE(col, 0)
NVL(col, 0)
ISNULL(col, 0)
CAST(s AS UNSIGNED)
s::integer
TO_NUMBER(s)
CAST(s AS INT)
CAST(s AS INT64)
CAST(s AS DATE)
s::date
TO_DATE(s, 'fmt')
PARSE_DATE('%Y-%m-%d', s)
data->'$.name'
data->>'name'
JSON_EXTRACT_SCALAR(data, '$.name')
JSON_VALUE(data, '$.name')
ROW_NUMBER()
RANK()
DENSE_RANK()
Syntax: RANK() OVER (PARTITION BY category ORDER BY score DESC)
RANK() OVER (PARTITION BY category ORDER BY score DESC)
GROUP_CONCAT(col)
STRING_AGG(col, ',')
LISTAGG(col, ',') WITHIN GROUP...
col REGEXP 'pat'
col ~ 'pat'
REGEXP_CONTAINS(col, 'pat')
REGEXP_REPLACE
ROUND(col, 2)
RAND()
RANDOM()
DBMS_RANDOM.VALUE
SHOW TABLES
\dt
SELECT * FROM user_tables
SELECT * FROM sys.tables
LIMIT 10
FETCH FIRST 10 ROWS ONLY
TOP 10 *
Check your SQL syntax or fix errors with our AI tools.