Select *, row_number () over (partition by MEMBER_ID order by COUNTPRODUCT_ID desc) as id0 from MEMBER.
Where id0=1
Always prompt I row_number missing operator...
I hope everybody help me have a look at