Resources

SQL Resources

Search SQL Resources ...

Top searches: AI, dbt Cloud™ pricing, IDE, Bolt

Introduction

Welcome to the SQL Dictionary—your comprehensive reference guide for essential SQL commands and functions. Whether you're a data analyst, engineer, or developer, mastering SQL is crucial for effective data manipulation and analysis across modern data platforms.

This dictionary covers fundamental and advanced SQL operations that you'll encounter in your day-to-day work.

Each command entry is designed to help you understand not just the syntax, but the practical applications and nuances across different SQL dialects. Use this dictionary as your go-to resource for quick lookups, learning new techniques, or refreshing your knowledge of SQL fundamentals.

Introduction

This dictionary covers fundamental and advanced SQL operations that you'll encounter in your day-to-day work.

AI.CLASSIFY (2)

AI.EMBED (2)

AI.GENERATE

AI.GENERATE_BOOL

AI.GENERATE_DOUBLE

AI.GENERATE_EMBEDDING

AI.GENERATE_INT

AI.GENERATE_TABLE

AI.GENERATE_TEXT

AI.IF

AI.SCORE

AI.SIMILARITY (2)

AI_AGG

AI_CLASSIFY

AI_COMPLETE

AI_COUNT_TOKENS

AI_EMBED

AI_EXTRACT

AI_FILTER

AI_PARSE_DOCUMENT

AI_REDACT

AI_SENTIMENT

AI_SIMILARITY

AI_SUMMARIZE_AGG

AI_TRANSCRIBE

AI_TRANSLATE

APPROX_COUNT_DISTINCT

ARRAY_AGG / ARRAY_CONSTRUCT

BETWEEN / IN / LIKE

CASE

CAST / CONVERT / TRY_CAST

CAST / TRY_CAST / CONVERT

COALESCE

COPY INTO

COUNT / SUM / AVG / MAX / MIN

CREATE TABLE / ALTER TABLE / DROP TABLE

CROSS JOIN / LATERAL JOIN

DATE_TRUNC / TRUNC

DISTINCT / LIMIT / OFFSET

EXTRACT / DATE_PART

FLATTEN / UNNEST / EXPLODE

GROUP BY / HAVING

INNER JOIN / LEFT JOIN / RIGHT JOIN / FULL OUTER JOIN

INSERT / UPDATE / DELETE

INTERSECT / EXCEPT (MINUS)

LAG / LEAD

MERGE (UPSERT)

NULLIF / IFF (IF)

PIVOT / UNPIVOT

QUALIFY

RANK / DENSE_RANK / NTILE

REGEXP_EXTRACT / REGEXP_SUBSTR

ROW_NUMBER

SELECT

SUBSTRING / SPLIT / CONCAT

TIME TRAVEL (AT / BEFORE / FOR SYSTEM_TIME AS OF)

UNION / UNION ALL

UPPER / LOWER / TRIM / LENGTH / REPLACE

WINDOW FUNCTIONS (FIRST_VALUE / LAST_VALUE / NTH_VALUE)

WITH (Common Table Expressions - CTEs)

AI.CLASSIFY (2)

AI.EMBED (2)

AI.GENERATE

AI.GENERATE_BOOL

AI.GENERATE_DOUBLE

AI.GENERATE_EMBEDDING

AI.GENERATE_INT

AI.GENERATE_TABLE

AI.GENERATE_TEXT

AI.IF

AI.SCORE

AI.SIMILARITY (2)

AI_AGG

AI_CLASSIFY

AI_COMPLETE

AI_COUNT_TOKENS

AI_EMBED

AI_EXTRACT

AI_FILTER

AI_PARSE_DOCUMENT

AI_REDACT

AI_SENTIMENT

AI_SIMILARITY

AI_SUMMARIZE_AGG

AI_TRANSCRIBE

AI_TRANSLATE

APPROX_COUNT_DISTINCT

ARRAY_AGG / ARRAY_CONSTRUCT

BETWEEN / IN / LIKE

CASE

CAST / CONVERT / TRY_CAST

CAST / TRY_CAST / CONVERT

COALESCE

COPY INTO

COUNT / SUM / AVG / MAX / MIN

CREATE TABLE / ALTER TABLE / DROP TABLE

CROSS JOIN / LATERAL JOIN

DATE_TRUNC / TRUNC

DISTINCT / LIMIT / OFFSET

EXTRACT / DATE_PART

FLATTEN / UNNEST / EXPLODE

GROUP BY / HAVING

INNER JOIN / LEFT JOIN / RIGHT JOIN / FULL OUTER JOIN

INSERT / UPDATE / DELETE

INTERSECT / EXCEPT (MINUS)

LAG / LEAD

MERGE (UPSERT)

NULLIF / IFF (IF)

PIVOT / UNPIVOT

QUALIFY

RANK / DENSE_RANK / NTILE

REGEXP_EXTRACT / REGEXP_SUBSTR

ROW_NUMBER

SELECT

SUBSTRING / SPLIT / CONCAT

TIME TRAVEL (AT / BEFORE / FOR SYSTEM_TIME AS OF)

UNION / UNION ALL

UPPER / LOWER / TRIM / LENGTH / REPLACE

WINDOW FUNCTIONS (FIRST_VALUE / LAST_VALUE / NTH_VALUE)

WITH (Common Table Expressions - CTEs)

AI.CLASSIFY (2)

AI.EMBED (2)

AI.GENERATE

AI.GENERATE_BOOL

AI.GENERATE_DOUBLE

AI.GENERATE_EMBEDDING

AI.GENERATE_INT

AI.GENERATE_TABLE

AI.GENERATE_TEXT

AI.IF

AI.SCORE

AI.SIMILARITY (2)

AI_AGG

AI_CLASSIFY

AI_COMPLETE

AI_COUNT_TOKENS

AI_EMBED

AI_EXTRACT

AI_FILTER

AI_PARSE_DOCUMENT

AI_REDACT

AI_SENTIMENT

AI_SIMILARITY

AI_SUMMARIZE_AGG

AI_TRANSCRIBE

AI_TRANSLATE

APPROX_COUNT_DISTINCT

ARRAY_AGG / ARRAY_CONSTRUCT

BETWEEN / IN / LIKE

CASE

CAST / CONVERT / TRY_CAST

CAST / TRY_CAST / CONVERT

COALESCE

COPY INTO

COUNT / SUM / AVG / MAX / MIN

CREATE TABLE / ALTER TABLE / DROP TABLE

CROSS JOIN / LATERAL JOIN

DATE_TRUNC / TRUNC

DISTINCT / LIMIT / OFFSET

EXTRACT / DATE_PART

FLATTEN / UNNEST / EXPLODE

GROUP BY / HAVING

INNER JOIN / LEFT JOIN / RIGHT JOIN / FULL OUTER JOIN

INSERT / UPDATE / DELETE

INTERSECT / EXCEPT (MINUS)

LAG / LEAD

MERGE (UPSERT)

NULLIF / IFF (IF)

PIVOT / UNPIVOT

QUALIFY

RANK / DENSE_RANK / NTILE

REGEXP_EXTRACT / REGEXP_SUBSTR

ROW_NUMBER

SELECT

SUBSTRING / SPLIT / CONCAT

TIME TRAVEL (AT / BEFORE / FOR SYSTEM_TIME AS OF)

UNION / UNION ALL

UPPER / LOWER / TRIM / LENGTH / REPLACE

WINDOW FUNCTIONS (FIRST_VALUE / LAST_VALUE / NTH_VALUE)

WITH (Common Table Expressions - CTEs)

Experience Analytics for the AI-Era

Start your 14-day trial today - it's free and no credit card needed

Start for free

Experience Analytics for the AI-Era

Start your 14-day trial today - it's free and no credit card needed

Start for free

Experience Analytics for the AI-Era

Start your 14-day trial today - it's free and no credit card needed

Start for free

Platform

Resources

ADD-ONs

Industries

About

Legal

Made with ❤️ in San Francisco ・ London

*dbt® and dbt Core® are federally registered trademarks of dbt Labs, Inc. in the United States and various jurisdictions around the world. Paradime is not a partner of dbt Labs. All rights therein are reserved to dbt Labs. Paradime is not a product or service of or endorsed by dbt Labs, Inc.

Start for free

Platform

Resources