Skip to Content
0
Former Member
Jan 05, 2017 at 03:42 AM

how to implement teradata qualify row number() over (partition by) in BODS

1089 Views

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.