Dear all,
I want to select distinct CODE and thier respective sex, sex can be male/female, can I get my result strictly distinct in code. Currently it duplicate code value for each male and female. I am using this query
select distinct(code), id from table
Regards,
imran