1 Reply Latest reply on Jun 6, 2006 8:15 AM by Newsgroup_User

    limited repeat of records in database field

    Level 7
      Hi,

      I have a task at hand.

      I have a table in a database.
      In a field, each data may repeat two or three times maximum. For example,

      Id Title Code
      1 John 450
      2 Abraham 414
      3 Marry 418
      4 Jennifer 414
      5 Mike 450
      6 Susan 412
      7 Jeff 450
      8 Tony 424

      I sense that it is easy. But, I could not figure out the logic yet

      Any solution would make my day.

      Thank you

      Hakan


        • 1. Re: limited repeat of records in database field
          Level 7
          SELECT DISTINCT `Title`,`Code` FROM TABLE_NAME;
          Mick

          Hakan834 wrote:

          > Hi,
          >
          > I have a task at hand.
          >
          > I have a table in a database.
          > In a field, each data may repeat two or three times maximum. For example,
          >
          > Id Title Code
          > 1 John 450
          > 2 Abraham 414
          > 3 Marry 418
          > 4 Jennifer 414
          > 5 Mike 450
          > 6 Susan 412
          > 7 Jeff 450
          > 8 Tony 424
          >
          > I sense that it is easy. But, I could not figure out the logic yet
          >
          > Any solution would make my day.
          >
          > Thank you
          >
          > Hakan
          >
          >