on 01-05-2017 3:42 AM
Hi,
I have a project requirement that requires to do push down sql for all filter conditions. The terdata sql code is as follows: qualify row number() over (partition by field1, field2 order by field1, field2) = 1. How do I write this using pushdown_sql in BODS?
Thanks.
thanks a lot Arun for your response.. that's also the other implementation that I was thinking but just checking if it's possible to implement it using pushdown_sql
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
The above statement cannot be used in the where clause because it contains aggregate function.
You can instead use gen_row_num_group() function.
Mapping for ROWNUM should be as below
Output should look something like below:
You can further filter out the ROWNUM with the value 1 🙂
Hope this is useful
Regards
Arun Sasi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.