Query Question

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux