Results 1 to 4 of 4

Thread: [RESOLVED] How to avoid duplicates ?

Threaded View

  1. Mar 30th, 2005, 04:53 AM #1
    AvisSoft
    AvisSoft is offline

    Thread Starter
    Hyperactive Member AvisSoft's Avatar
    Join Date
    Sep 2002
    Location
    Chandigarh
    Posts
    459

    Resolved [RESOLVED] How to avoid duplicates ?

    Hello,

    I have a database in which there are members, i need to extract the countries out of this members database and do not list countries again and again for example:

    suppose there are 3 members, 2 from US and 1 from UK. Now i run a simple query i.e: SELECT * FROM members ...this query will now list 3 member countries i.e:

    US
    US
    UK

    whereas i just want it like:

    US
    UK

    How can i achieve this ?

    Thanks.
    Last edited by AvisSoft; Mar 30th, 2005 at 05:26 AM.
    Tapan Bhanot,
    CEO, Avis Software.
    Website: www.avissoftware.com
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width