I need a little bit of syntax help writing a SQL Code for Select Distinct on multiple columns using the in-DB filter tool. I only want records that have the same zip code and ID. I want to go this route so I don't have to stream out the data and use the unique tool.
Solved! Go to Solution.
I would try the In-DB summerize tool; if you configure this with the ‘first’ summerize type you can achieve exactly the same as you would with an In-DB unique.
Ben
I don't see "First" in the In-DB Tool. Perhaps, I need an upgrade? I am using 11.7.
According to the help it has exited in the in database summerize tool since version 9.5.
I believe it sits under the ‘string’ group.
That is strange. I don't have that option for the In-DB tool. I felt like I have seen this before. Nonetheless, I think Group By without the first probably could work for my use case. I will give this a try. If you have any other thoughts please share. Thanks.
I need some help writing the sql statement in the
Filter In-DB Tool
Select a,b,c, d from table xyz
where a,b,c is null