dcsimg
www.webdeveloper.com
Results 1 to 5 of 5

Thread: Filter repeat

  1. #1
    Join Date
    Nov 2006
    Posts
    9

    Wink Filter repeat

    Need help on how to filter away repeated name.

    I need to retrieve a name column from a table in database. But inside the name column there is some repeated names. What should my SQL look like if I don't want to display those repeated names???

    Thanks.

  2. #2
    Join Date
    Jun 2005
    Location
    Winston-Salem, NC
    Posts
    318
    SELECT DISTINCT NameField FROM TableName

  3. #3
    Join Date
    Nov 2006
    Location
    Singapore
    Posts
    12
    Thanks you hehex though the question not ask by me. I needed that answer too.
    Last edited by yuling86; 11-21-2006 at 08:12 PM.

  4. #4
    Join Date
    Jun 2005
    Location
    Winston-Salem, NC
    Posts
    318
    No Problem

  5. #5
    Join Date
    Nov 2006
    Posts
    9
    Thanks

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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



Recent Articles