NoSQL queries - Azure Cosmos DB for NoSQL (original) (raw)

Azure Cosmos DB for NoSQL has the ability to query data by writing queries using the Structured Query Language (SQL) as a JSON query language.

Concepts

Reference

• Subqueries
• Joins
• Keywords
• Constants

Vector functions

Reference

• VectorDistance

Aggregate functions

Reference

• AVG
• COUNT
• Maximum
• Minimum
• SUM

Array functions

Reference

• ARRAY_CONCAT
• ARRAY_CONTAINS
• ARRAY_CONTAINS_ANY
• ARRAY_CONTAINS_ALL
• ARRAY_LENGTH
• ARRAY_SLICE

Date and time functions

Reference

• GetCurrentDateTime
• GetCurrentTicks
• GetCurrentTimestamp

Mathematical functions

Reference

• ABS
• EXP
• SIN