Enhanced SQL API query functionality in Azure Cosmos DB is now available

Azure Cosmos DB SQL API provides support for Distinct, Skip & Take, Correlated Subquery, and Composite indexes.
Source: Microsoft Azure – aggiornamenti