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
2061
May 3, 2018
JOIN on two sub queries
SQL++
1
1154
March 28, 2019
How to query all latest versions after implementing document versioning
SQL++
query
,
n1ql
2
946
July 26, 2021
Need Join for 2 documents based on fields
SQL++
n1ql
4
1745
August 2, 2016
Using JOIN, Aggregate function SUM() and GROUP BY without affecting query execution time
SQL++
query
,
n1ql
6
1132
September 1, 2020