This is indeed not really the right forum for that because it appears you are actually looking to move out of KNIME and put it directly in a query . The internet is your best friend in this case.
You are looking for operators like WHERE, DISTINCT, GROUP BY, CONCAT.
Some explanations on its usage in basic form:
Hi @berserkersap , the operations/statements that @ArjenEX provided are correct, and on top of the w3schools resources that @ArjenEX suggested, you can also look for these on the mysql doc pages too.
Hello @ArjenEX , @bruno29a , @mlauber71
Thank you for your replies.
Actually I know I can get most of those on internet.
However, I am particularly worried about duplicate row filter, on how to retain order and get the top first row and remove others like how KNIME does.
If I just ignore the order, I think I can use row_number() over window function to get the duplicates.
I am not that much of a KNIME expert but by mlauber71 words, it seems we can use SQL nodes by particularly writing a query in them (Well right now I am not worried about databases). However, I want to know if these nodes use non java related engines ?
(Honestly I want to get accuracy in numbers but as double data type in regular nodes cannot provide it , I wanted to explore new options. However, if SQL nodes give accuracy that can make things simpler maybe )
Maybe you take a look at this article dealing with duplicates. The other link would give you an example how to use Window functions like rank to control what would count as a duplicate.