User Profile

Collapse

Profile Sidebar

Collapse
hganta
hganta
Last Activity: Jan 12 '08, 03:38 PM
Joined: Oct 6 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • hganta
    started a topic retrieve duplicates
    in MySQL

    retrieve duplicates

    hai all,

    Can any one pls send me query on the following.

    I have a table product_tbl where the data will be stored like

    ProductID Productname
    905139078 Modular Substations
    905138916 Motor Control Centers
    904866565 Modular Substations

    The productid is the unique one but the productname is duplicate.

    I want to retrieve...
    See more | Go to post
    • hganta
      started a topic same ids in a tbl
      in MySQL

      same ids in a tbl

      hai,

      I have businessrel_tbl in which a column businessreltype pairid is existing.

      In the businessreltype pairid there will be relateionids for auditor(17), client(16), supplier(2) etc.

      I want to retrieve data with both auditor and client ids. can any one please provide me the query.
      See more | Go to post
      • hganta
        replied to retrieve duplicates
        in SQL Server
        Product Productgroup
        XYZ ABC
        ... ...
        MNK XYZ

        s exactly that is what i mean.

        please provide me the query on this.

        I want to retrive the XYZ cases both in product and productgroup.
        See more | Go to post

          Leave a comment:

        • hganta
          replied to retrieve duplicates
          in SQL Server
          retrieve duplicates

          HI,

          I have a table product_tbl in which two columns exists. productname and productgroup. The productname of one row will be matched with another row of the productgroup in the table product_tbl. Can u please give me the query on this one....

          Thanks
          See more | Go to post

            Leave a comment:

          • hganta
            replied to retrieve duplicates
            in SQL Server
            HI,

            Thanks for ur response

            But my query is not for the same row in the columns. The productname of one row will be matched with another row of the productgroup in the table product_tbl. Can u please give me the extended one....

            Thanks...
            See more | Go to post

              Leave a comment:

            • hganta
              started a topic retrieve duplicates
              in SQL Server

              retrieve duplicates

              Hai,

              I am having a table with name product_tbl wherin two columns exists productname and productgroup. Can u please give me a query wherin i can retrieve values of same in the two columns.

              Thanks
              See more | Go to post
              No activity results to display
              Show More
              Working...