I have a table that has some duplicates. I can count the distinct records to get the Total Volume. When I try to Sum when the CompTia Code is B92 and run distinct is still counts the dupes.
 
Here is the query:

Hi guys, 
I'm using java querydsl library to generate query to teradata. I want to build query with distinct values and limit. I'm expecting query like:
    select distinct ts.Gender
    from table ts
    order by ts.Gender asc
    limit 1000
(this query also generated by querydsl for another sql database)

Good morning TD community,