SQL syntax features

SQream DB supports SQL from the ANSI 92 syntax.

SQL syntax topics

• Keywords and Identifiers
  • Keywords
  • Identifiers
  • Reserved keywords
• Literals
  • Number literals
  • String literals
  • Typed literals
  • Other constants
• Scalar expressions
  • Literals
  • Column references
  • Operators
• Joins
  • Syntax
  • Examples
• Common table expressions (CTEs)
  • Syntax
  • Examples
• Window functions
  • Syntax
  • Arguments
  • Supported window functions
  • How window functions work
  • Limitations
  • Examples
• Subqueries
  • Examples
• Null handling
  • Comparisons
  • Conditionals
  • Operations
  • Sorting