I want to retrieve distinct values from the database table. How can I do that using databaseretrieve node? I am using wmb v220.127.116.11
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