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
|