I'm writing a DB source that requires subqueries. The central subquery requires the data to be grouped by and sorted by so that we don't get any odd results. I have tried to write it that way but for some reason, it's not liking that and says "Expected Semicolon or end of input but "(" found".
I run the same code outside of NAB and it works fine but it's only when I try to put it in the NAB that it has issues. Is there a reason why it's not being accepted here?
Here is this as a simplified example of our code:
I run the same code outside of NAB and it works fine but it's only when I try to put it in the NAB that it has issues. Is there a reason why it's not being accepted here?
Here is this as a simplified example of our code:
Code:
select * from ( SELECT t1.a, t1.b, t1.c, count(*) AS numcount FROM( SELECT t1.a, t1.b, t1.c FROM file1 AS t1 GROUP BY t1.a, t1.b, t1.c order BY t1.a, t1.b, t1.c ) GROUP BY t1.a, t1.b, t1.c ORDER BY t1.a, t1.b, t1.c ) where numcount > 1
Comment