Hi i am trying to implement sub-query in the select itself Document 1: { “Date”: “2016/12/01”, “IpAddress”: “192.168.0.1”, “Region”: “Sout-Asia”, “Country”: “India”, “State”: “Gujarat”, “City”: “Ahmedabad”, “UserAgent”: “Mozilla”, “Device”: “”, “Impression”: “0”, “Click”: “1”, “Platform…

Hi @siddharth.ruchwani , Form query my understanding is UniqueClicks expression that you are looking when CLick = 1 want to count distinct ip addresses. This can be achieved without subquery and joins with the following query. SELECT s.Platform, COUNT(DISTINCT s.Channel) AS Channels, COUNT(DISTINCT…

N1QL subquery in select

SQL++

moumita.b.ghosh October 16, 2017, 1:56pm 17

Thanks a lot. Really appreciate your help…

Topic		Replies	Views
Help about SubQuery SQL++	4	1526	May 28, 2017
N1QL - select from subquery SQL++ query , n1ql	2	2623	August 9, 2016
N1QL Joins on same bucket but with different type of document SQL++	6	12878	May 4, 2016
SQL like subqueries SQL++	1	596	July 26, 2019
How to USE KEYS in N1QL subquery SQL++ 40-rc	15	18706	September 23, 2020

N1QL subquery in select

Related topics