How to print values from result set without any duplicated record from column

Question

I have created code. Please check the link from the comment. i'm trying to write code which gives unique records for specific column but not for all columns. also tried [while(rs.next())]. but it prints all records with duplicated column values. i want to print table which is unique for specific two columns and duplicated values contain in other columns.Please prefer image which provide below then you will get exact idea what i'm looking for.

now here you can see left side table contain all duplicated values of column are extracted from result set. but i want all records but not duplicate values for first two columns.

PLEASE PREFER MY CODE https://jsfiddle.net/s2kbugm7/ – Arch8 Apr 10 '19 at 07:53 — Arch8, Apr 10 '19 at 07:53

score 1 · Answer 1 · answered Apr 10 '19 at 11:01

You want to do it in SQL or in Java? In Java, you can just (I'll do it for one value, you can figure it out for the others):

    String lastUsername;
    while (rs.next()) {
       String username = rs.getString("username");
       if (username.equals(lastUsername)) username = "";
       else lastUsername = username;

       // print username or whatever you need to do with it
    }

You should also make sure that your data set is actually ordered by something, at least the columns you want to replace:

SELECT DISTINCT username, empid, leavetype,remainingleave,requiredleave,STATUS 
  FROM request 
 ORDER BY username, empid

How to print values from result set without any duplicated record from column

1 Answers1