Couchbase Forums
Select non-group by fields using sql query
SQL++
query
vsr1
May 7, 2018, 10:15pm
2
SELECT MAX([created,jobId])[1] AS jobId FROM default WHERE .. GROUP BY jobGroup, region;
1 Like
Help with correlated subquery please
Find docs with "largest" value per (or grouped by) a category
N1QL Query Performance Issue - Declines on volume of data fetch
show post in topic