Need help in refactoring query as Grid db doesn’t support with clause CTE
I am working on a project where I need to use the “WITH” clause to create CTE’s in my queries. This works well in MSSQL, but I found out that GridDB does not support the “WITH” clause. I tried using below mentioned way: