is there another way for getting the json doc associated with a MAX value? This works because I limit it to 1 SELECT * FROM myBucket AS buck LET maxClic = (SELECT RAW MAX(clicks) from myBucket) WHERE buck.clicks <= maxClic ORDER BY buck.clicks desc LIMIT 1 But when I say buck.clicks = maxCli…

Basic Max aggregate

vsr1 May 23, 2018, 5:26am 5

Explanation is given above link. Please read here Select non-group by fields using sql query

Topic		Replies	Views
Find docs with "largest" value per (or grouped by) a category SQL++ n1ql	2	1373	August 22, 2018
Issue In Subquery SQL++	3	542	April 1, 2021
Query and get up to maximum items per group SQL++	4	876	September 19, 2019
How can i use Let and Subquery result to update or insert Data SQL++	3	859	September 17, 2022
Returning distinict document matching the aggregate MAX result with GROUP BY Couchbase Server query , n1ql	6	2860	November 25, 2020