how to compare row by row

[Baktha Elumalai]

i have table Xydata i am getting gstime from the table

 preparedStatement = conn1.prepareStatement("select gstime from xydata a inner join fm4features f on a.ID=f.ID where a.objectId= '18'  AND a.clientId = '1' AND a.gstime > '2010-04-01 00:00:00'  AND a.gstime < ' AND f.DataId='1' AND f.value = '1' GROUP  BY a.gstime");
        rs = preparedStatement.executeQuery();
         List<String> date1 = new ArrayList<String>();
           List<Integer> hh1 = new ArrayList<Integer>();
           List<Integer> mm1 = new ArrayList<Integer>();
           List<String> ss1 = new ArrayList<String>();
         while (rs.next())
            {   
                String output[];
                String temp[];
                *String gstime = rs.getString("GsTime");*
                String Date= gstime.substring(0,10);
                String hh2 = gstime.substring(11,13);
                String mm2 = gstime.substring(14,16);
                String ss2 = gstime.substring(17,19);
                System.out.println("+Date  +hh2+  +mm2+  +ss2");
        }
 
     

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

2010-05-08 20 18 
2010-05-08 20 18  
2010-05-08 20 19  
2010-05-08 20 19  
2010-05-08 20 21  

Final Output after compare row by row and delete duplicate row

2010-05-08 20 18 
2010-05-08 20 19  
2010-05-08 20 21  

i need this type of ouput

please help me if any body know the idea

[Istvan Kovacs]

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

[James Sabre]

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.