Results 1 to 2 of 2
  1. #1
    Jdevelop is offline Member
    Join Date
    Jun 2011
    Posts
    1
    Rep Power
    0

    Default How to get unique rows from a table

    i've a file with data in the following format

    id element1 element2 element3 element4 elemet5
    1 A B C NULL NULL
    2 A D NULL NULL NULL
    3 C B A NULL NULL
    4 A D NULL NULL NULL
    5 F C A O B

    i want to get the unique rows only ,in above example rows with ids 1 and 3 are redundant(have the same elements,the sequence doesn't matter) and rows 2 and 4 are also redundant.

    i would like to know the most efficient way to get the unique rows from the above table.

    Thank you very much.

  2. #2
    Petr's Avatar
    Petr is offline Senior Member
    Join Date
    Jan 2011
    Location
    Russia
    Posts
    620
    Rep Power
    10

    Default

    Hi, You can read need's data and then put it in special collection, which can't has duplicate elements as like Set.
    Skype: petrarsentev
    http://TrackStudio.com

Similar Threads

  1. Replies: 0
    Last Post: 03-03-2011, 02:20 PM
  2. how to add rows to a child table automaticall
    By kulangotski in forum JDBC
    Replies: 7
    Last Post: 01-13-2011, 11:48 AM
  3. Replies: 1
    Last Post: 04-23-2009, 07:55 PM
  4. Updating Displayed Table Rows
    By raycini in forum JavaServer Faces (JSF)
    Replies: 2
    Last Post: 04-20-2009, 08:24 AM
  5. Color cells and rows in SWT table
    By Java Tip in forum SWT Tips
    Replies: 0
    Last Post: 07-11-2008, 04:31 PM

Posting Permissions

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