JDBC Driver for Azure Cosmos DB

Build 22.0.8462


The GROUP BY clause divides the query's results according to the values of one or more specified properties. This operation is partially done server-side because of some API limitations. We still need to operate a client-side grouping.

GROUP BY Examples

SELECT COUNT(*) AS CNT, gender FROM [users] GROUP BY gender
SELECT COUNT(*) AS CNT, gender, doc_type FROM [users] GROUP BY gender, doc_type

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462