I have an oracle query which I want to translate into corresponding Couchbase’s n1ql query.
select EMPNO, to_date,from_date, row_number() over (order by from_date asc) as JoiningRank, row_number() over (order by from_date desc) as ExperinceRank from [dbo].[EMPHISTORY]
As Row_Number() is being used here, I could not find an alternate way to write this query in n1ql.
I read somewhere that Row_Number() function (window functions) is available in 6.5 version.
- Since I am using 6.0 right now, is there any way to implement this query in n1ql?
- Does Couchbase 6.5 support this Row_Number() function? If yes, only EE or CE as well ?
Please help to re-write this query in n1ql.