>I need one SQL statement that will return records with no duplicates based on case:
>
>
>Raw data example:
>
>Aa
>Bb
>CC
>aa
>Dd
>bb
>aA
>ee
>
>Desired result set:
>
>Aa
>Bb
>CC
>Dd
>ee
>
Hi Jay,
You haven't specified why you're choosing "Aa" and not "aA." If you want the first one you see then you'd need to order them somehow and go from there. If you just want any one then the advice to select the MIN() is probably ok.