Logo
Back to data.world Submit a request
Sign in
  • Home
  • {[{category.name}]}
    • {[{section.name}]}
      • {[{article.title}]}
  1. data.world help center
  2. Reference
  3. SQL

SQL content index

Keywords and Concepts

aggregate function
aggregation
AND
arithmetic operations
AS
ASC
AVG
backtick `
BETWEEN
CASE
CAST
clause
column
comments
comparison operators
CONCAT
COUNT
COUNT *
CROSS JOIN
CUBE
data
dataset
DATE_ADD
DATE_DIFF
DATE_PART
DESC
DISTINCT
ELSE
END
federated queries
FILTER
FOR
FROM
FULL JOIN
GROUP_BY
GROUP_CONCAT
HAVING
identifiers
IN
inline subqueries
INNER JOIN
INTERSECT
IS NOT NULL
IS NULL
JOIN ON
JOIN USING
joins
keyword
LEFT
LEFT JOIN
LENGTH
LIKE
LIMIT
LOWER
MAX
MIN
MINUS
multi-tables
NATURAL JOIN
NOT
NOT IN
NOT LIKE
NOW
Numeric Operations
OFFSET
OR
ORDER BY
OUTER JOIN
PIVOT
POSITION
project
query
relational database
RIGHT JOIN
ROLLUP
row
Schemata
SELECT
self join
SEPARATOR
special columns
SQL
strings
subquery special uses
SUBSTRING
SUM
table
table_name
Tablecolumns
Tables
TABLESAMPLE
THEN
UNION
UNPIVOT
UPPER
WHEN
WHERE
wildcard _
wildcard .*
wildcard *
wildcard %
WITH
Prev {[{nav.prev.title}]}
Next {[{nav.next.title}]}
  • Pricing
  • Security
  • Policy
  • Terms
  • Privacy
  • We’re hiring!
© 2021 data.world, Inc.