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
    4

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