SQLite 3.39

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

CREATE TABLE tablename (Score INTEGER, Timestamp TEXT, Notes TEXT);
✓
INSERT INTO tablename (Score, Timestamp, Notes) VALUES
  ('5', '2022-08-09 00:12', null),
  ('6', '2022-08-09 01:15', null),
  ('2', '2022-08-09 01:30', 'worse than current high score of 6, so no asterisk'),
  ('10', '2022-08-09 02:01', null),
  ('7', '2022-08-09 03:45', 'worse than current high score of 10'),
  ('12', '2022-08-09 03:50', null),
  ('1', '2022-08-10 00:05', 'note different day!'),
  ('6', '2022-08-10 01:01', null);
✓
WITH cte AS (
  SELECT *, Score = MAX(Score) OVER (ORDER BY Timestamp) flag
  FROM tablename
  WHERE date(Timestamp) = '2022-08-09'
)
SELECT Score, time(Timestamp) Timestamp, Notes
FROM cte
WHERE flag;


Score
Timestamp
Notes


5
00:12:00
null

6
01:15:00
null

10
02:01:00
null

12
03:50:00
null

Score	Timestamp	Notes
5	00:12:00	null
6	01:15:00	null
10	02:01:00	null
12	03:50:00	null