aspose file tools*
The moose likes Java in General and the fly likes how to compare row by row Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Java » Java in General
Bookmark "how to compare row by row" Watch "how to compare row by row" New topic
Author

how to compare row by row

Baktha Elumalai
Greenhorn

Joined: Mar 13, 2010
Posts: 28
i have table Xydata i am getting gstime from the table



we want to compare the time hh, mm row by row (if the row is repeated delete the row else row is printed.
if row is repeated delete the one row
ouput


Final Output after compare row by row and delete duplicate row


i need this type of ouput

please help me if any body know the idea


Regards
Bakthavachalam E
Istvan Kovacs
Ranch Hand

Joined: May 06, 2010
Posts: 100
Why don't you filter out duplicates at the SQL level using SELECT DISTINCT?
James Sabre
Ranch Hand

Joined: Sep 07, 2004
Posts: 781

Istvan Kovacs wrote:Why don't you filter out duplicates at the SQL level using SELECT DISTINCT?


This has been suggested on at least one of his many cross posts (at least 5 to my knowledge) of this topic.
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: how to compare row by row