I want to retrieve distinct values from the database table. How can I do that using databaseretrieve node? I am using wmb v126.96.36.199
Or is there any alternative to this node apart from using ESQL or java compute node?
My query is something like this: Select distinct col1, col2, col3...from table1...
Would Appreciate any help.
Thanks in Advance