MySQL-এ ডুপ্লিকেট মান ও সর্বোচ্চ তারিখ একসাথে প্রদর্শন

এজন্য GROUP BY এবং HAVING ব্যবহার করুন।

টেবিল তৈরি করা

mysql> create table DemoTable 
( 
  StudentName varchar(100), 
  DueDate date 
); 
Query OK, 0 rows affected (0.72 sec)

রেকর্ড ইনসার্ট করা

mysql> insert into DemoTable values('John','2019-01-11'); 
Query OK, 1 row affected (0.26 sec) 
mysql> insert into DemoTable values('Chris','2019-02-11'); 
Query OK, 1 row affected (0.20 sec) 
mysql> insert into DemoTable values('Chris','2019-03-11'); 
Query OK, 1 row affected (0.19 sec) 
mysql> insert into DemoTable values('John','2019-04-11'); 
Query OK, 1 row affected (0.12 sec) 
mysql> insert into DemoTable values('Bob','2019-05-11'); 
Query OK, 1 row affected (0.17 sec) 
mysql> insert into DemoTable values('Bob','2019-06-11'); 
Query OK, 1 row affected (0.15 sec) 
mysql> insert into DemoTable values('Robert','2019-07-11'); 
Query OK, 1 row affected (0.18 sec) 
mysql> insert into DemoTable values('Robert','2019-08-11'); 
Query OK, 1 row affected (0.17 sec) 
mysql> insert into DemoTable values('Robert','2019-09-11'); 
Query OK, 1 row affected (0.15 sec)

সকল রেকর্ড প্রদর্শন

mysql> select *from DemoTable;

আউটপুট

+-------------+------------+ 
| StudentName | DueDate    | 
+-------------+------------+ 
| John        | 2019-01-11 | 
| Chris       | 2019-02-11 | 
| Chris       | 2019-03-11 | 
| John        | 2019-04-11 | 
| Bob         | 2019-05-11 | 
| Bob         | 2019-06-11 | 
| Robert      | 2019-07-11 | 
| Robert      | 2019-08-11 | 
| Robert      | 2019-09-11 | 
+-------------+------------+ 
9 rows in set (0.00 sec)

ডুপ্লিকেট মান ও সর্বোচ্চ তারিখ প্রদর্শনের কোয়েরি

mysql> select tbl.StudentName,max(tbl.DueDate) from DemoTable tbl group by tbl.StudentName having count(*) > 1;

আউটপুট

+-------------+------------------+ 
| StudentName | max(tbl.DueDate) | 
+-------------+------------------+ 
| John        | 2019-04-11       | 
| Chris       | 2019-03-11       | 
| Bob         | 2019-06-11       | 
| Robert      | 2019-09-11       | 
+-------------+------------------+ 
4 rows in set (0.00 sec)