Post reply

Suppress data that is being repeated

  • October 7, 2005 at 10:13 am

    #90208

    Is it possible to suppress repeated data in sql (mysql 4.x)

    for e.g.

    Jack 123 dog

                 cat

                 cow

    Jill 234  pig

               dog

               sheep

     

    etc.......

  • October 7, 2005 at 10:17 am

    #595934

    I'm not exactly sure what your asking.

    Is this your sample data?

    what do you want it to look like after your done?

    I do not see repeated data.

    Can you elaborate on your problem/question?

    thx

  • October 7, 2005 at 11:20 am

    #595957

    I want it to look like the way I have posted it.

    The data I have looks like this

    Jack 123 dog

    Jack 123 cat

    Jack 123 cow

    Jill 234 cat

    Jill 234 pig

    Jill 234 sheep

  • October 7, 2005 at 5:18 pm

    #596110

    I don't use mysql,

    But I know that you cannot do that in sql server,

    Thats not how relational databases work.

     

  • October 8, 2005 at 10:57 am

    #596152

    Ray - just as an fyi - someone else had a similar question once (using t-sql) and I always post lee's solution when I see something like this...







    **ASCII stupid question, get a stupid ANSI !!!**

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply