MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select version();


version()


8.0.27


CREATE TABLE myTable AS
SELECT * FROM
(SELECT '2021-10-27' eDate UNION ALL 
SELECT '2021-10-28' UNION ALL
SELECT '2021-11-03' UNION ALL 
SELECT '2021-11-10' UNION ALL 
SELECT '2021-11-17' UNION ALL 
SELECT '2021-11-24' UNION ALL 
SELECT '2021-12-01' UNION ALL 
SELECT '2021-12-08') D
CROSS JOIN (SELECT 1 ID UNION SELECT 2 UNION SELECT 3) v
WITH cte AS (SELECT eDate, ID, ROW_NUMBER() OVER (PARTITION BY ID ORDER BY eDate) eCount
  FROM myTable WHERE eDate>=CURDATE()
  ORDER BY ID, eDate) 
SELECT * FROM cte WHERE eCount <=2;


eDate
ID
eCount


2021-11-03
1
1

2021-11-10
1
2

2021-11-03
2
1

2021-11-10
2
2

2021-11-03
3
1

2021-11-10
3
2


SELECT eDate, ID, rownum
FROM
   ( SELECT *,
           @rn:=CASE WHEN @i = ID AND eDate >= CURDATE()
                   THEN @rn + 1
                   ELSE 0 END AS rownum,
            @i := ID
        FROM myTable m  
         CROSS JOIN (SELECT @i:=0, @rn:=0)  r
       ORDER BY ID, eDate) v
 WHERE rownum > 0 AND rownum <= 2 
ORDER BY ID, eDate;
 


eDate
ID
rownum


2021-11-03
1
1

2021-11-10
1
2

2021-11-03
2
1

2021-11-10
2
2

2021-11-03
3
1

2021-11-10
3
2


DELETE FROM myTable WHERE ID=3 AND eDate >= '2021-11-10';
DELETE FROM myTable WHERE ID=1 AND eDate > '2021-11-10';
SELECT * FROM myTable WHERE ID IN (1,3) AND eDate>=CURDATE() ORDER BY eDate LIMIT 4 ;


eDate
ID


2021-11-03
3

2021-11-03
1

2021-11-10
1

eDate	ID	eCount
2021-11-03	1	1
2021-11-10	1	2
2021-11-03	2	1
2021-11-10	2	2
2021-11-03	3	1
2021-11-10	3	2