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
N1Q1 get documents where field is of the highest value when group by 2 fields SQL++	12	5488	October 3, 2017
N1QL query for deleting duplicate records in JSONArray Document SQL++	10	2385	April 5, 2020
Select document attribute and array element attribute based on aggregate operator applied to array element SQL++	1	1125	December 15, 2017
Returning distinict document matching the aggregate MAX result with GROUP BY Couchbase Server query , n1ql	6	2894	November 25, 2020
How to remove repetition? SQL++	2	938	November 8, 2017