SQLite 3.27

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

CREATE TABLE my_table (`NAME` VARCHAR(8), `FK1` VARCHAR(4), `FK2` INTEGER, `WATCH` INTEGER);
INSERT INTO my_table (`NAME`, `FK1`, `FK2`, `WATCH`) VALUES
  ('AAAAAAAA', NULL, '10099999', '1'),
  ('AAAAAAAA', '8008', '10099999', '1'),
  ('BBBBBBBB', '1111', '30088888', '2'),
  ('CCCCCCCC', '2222', '75656463', '1'),
  ('DDDDDDDD', '3333', '34242434', '2'),
  ('GGGGGGGG', NULL, '70099999', '1'),
  ('GGGGGGGG', '4224', '70099999', '1');
SELECT NAME, MAX(FK1) FK1, FK2, WATCH
FROM my_table
WHERE WATCH = 1
GROUP BY NAME;


NAME
FK1
FK2
WATCH


AAAAAAAA
8008
10099999
1

CCCCCCCC
2222
75656463
1

GGGGGGGG
4224
70099999
1


DELETE FROM my_table;
INSERT INTO my_table (`NAME`, `FK1`, `FK2`, `WATCH`) VALUES
  ('KKKKKKKK', NULL, '87656463', '1'),
  ('LLLLLLLL', '5454', '65453535', '2'),
  ('MMMMMMMM', NULL, '48723747', '1'),
  ('MMMMMMMM', '9229', '48723747', '1'),
  ('NNNNNNNN', '2765', '77000007', '2'),
  ('OOOOOOOO', NULL, '83343343', '1'),
  ('ZZZZZZZZ', '8118', '63737422', '1');
SELECT NAME, MAX(FK1) FK1, FK2, WATCH
FROM my_table
WHERE WATCH = 1
GROUP BY NAME;


NAME
FK1
FK2
WATCH


KKKKKKKK
null
87656463
1

MMMMMMMM
9229
48723747
1

OOOOOOOO
null
83343343
1

ZZZZZZZZ
8118
63737422
1

NAME	FK1	FK2	WATCH
AAAAAAAA	8008	10099999	1
CCCCCCCC	2222	75656463	1
GGGGGGGG	4224	70099999	1

NAME	FK1	FK2	WATCH
KKKKKKKK	null	87656463	1
MMMMMMMM	9229	48723747	1
OOOOOOOO	null	83343343	1
ZZZZZZZZ	8118	63737422	1