MySQL 8.0

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

CREATE TABLE phoneemail (
  `ID` VARCHAR(15),
  `NAME` VARCHAR(5),
  `PHONENO` VARCHAR(15),
  `EMAIL` VARCHAR(100),
  `TMDate` DATE
);

INSERT INTO phoneemail
  (`ID`, `NAME`, `PHONENO`, `EMAIL`, `TMDate`)
VALUES
  ('1234', 'Sarah', '0884100300', null, '2020-01-01'),
  ('1234', 'Sarah', '0881500900', null, '2020-03-05'),
  ('1234', 'Sarah', null, 'Sarah@gmail.com', '2020-03-10'),
  ('0001', 'James', '09991234567', null, '2020-12-31'),
  ('0001', 'James', null, 'james@yahoo.com', '2020-12-31');

Records: 5  Duplicates: 0  Warnings: 0


SELECT DISTINCT p1.ID, p1.NAME,
  (SELECT p2.PHONENO FROM phoneemail p2 
   WHERE (p2.ID, p2.NAME) = (p1.ID, p1.NAME) AND p2.PHONENO IS NOT NULL 
   ORDER BY TMDate DESC LIMIT 1) PHONENO,
  (SELECT p3.EMAIL FROM phoneemail p3 
   WHERE (p3.ID, p3.NAME) = (p1.ID, p1.NAME) AND p3.EMAIL IS NOT NULL 
   ORDER BY TMDate DESC LIMIT 1) EMAIL 
FROM phoneemail p1


ID
NAME
PHONENO
EMAIL


1234
Sarah
0881500900
Sarah@gmail.com

0001
James
09991234567
james@yahoo.com


SELECT DISTINCT ID, NAME,
       FIRST_VALUE(PHONENO) OVER (PARTITION BY ID, NAME ORDER BY PHONENO IS NULL, TMDate DESC) PHONENO,
       FIRST_VALUE(EMAIL) OVER (PARTITION BY ID, NAME ORDER BY EMAIL IS NULL, TMDate DESC) EMAIL
FROM phoneemail 


ID
NAME
PHONENO
EMAIL


0001
James
09991234567
james@yahoo.com

1234
Sarah
0881500900
Sarah@gmail.com

ID	NAME	PHONENO	EMAIL
1234	Sarah	0881500900	Sarah@gmail.com
0001	James	09991234567	james@yahoo.com