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
Related topics
Topic
Replies
Views
Activity
Group most recent documents by key
SQL++
query
1
2071
May 3, 2018
JOIN on two sub queries
SQL++
1
1171
March 28, 2019
How to query all latest versions after implementing document versioning
SQL++
query
,
n1ql
2
976
July 26, 2021
Couchbase Query not working as expected
SQL++
2
1631
July 17, 2016
Issue with N1QL query with GROUP BY
SQL++
n1ql
,
index
2
860
October 18, 2019