In-DB Select Distinct on Two Columns Using Filter In-DB

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.

Tips and Tricks

In Database

In-Database

Accepted answers

BenMoss

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

All comments

BenMoss

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

dshaw

I don't see "First" in the In-DB Tool. Perhaps, I need an upgrade? I am using 11.7.

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703