Results 1 to 3 of 3

Thread: SQL and repeating values

  1. Sep 8th, 2004, 12:35 PM #1
    Technocrat
    Technocrat is offline

    Thread Starter
    Frenzied Member Technocrat's Avatar
    Join Date
    Jan 2000
    Location
    I live in the 1s and 0s of everyones data streams
    Posts
    1,024

    SQL and repeating values

    How can I sort out a SELECT statement to return only 1 instance of a repeating value. For example:

    Test
    Test
    Test
    Test
    MoreTest
    MoreTest
    Something
    LastOne

    SELECT Return = Test, MoreTest, Something, LastOne
    MSVS 6, .NET & .NET 2003 Pro
    I HATE MSDN with .NET & .NET 2003!!!

    Check out my sites:
    http://www.filthyhands.com
    http://www.techno-coding.com

    Reply With Quote Reply With Quote
  2. Sep 8th, 2004, 12:52 PM #2
    brucevde
    brucevde is offline
    PowerPoster
    Join Date
    Oct 2002
    Location
    British Columbia
    Posts
    9,758
    Try Select Distinct or Select DistinctRow(MS Access).
    Reply With Quote Reply With Quote
  3. Sep 8th, 2004, 01:06 PM #3
    Technocrat
    Technocrat is offline

    Thread Starter
    Frenzied Member Technocrat's Avatar
    Join Date
    Jan 2000
    Location
    I live in the 1s and 0s of everyones data streams
    Posts
    1,024
    Perfect Thanks!
    MSVS 6, .NET & .NET 2003 Pro
    I HATE MSDN with .NET & .NET 2003!!!

    Check out my sites:
    http://www.filthyhands.com
    http://www.techno-coding.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