By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
WITH Activity AS (
SELECT 11145 AS ID, 'Reg' AS Name, 111 AS TID UNION ALL
SELECT 14008, 'Inn', 111 UNION ALL
SELECT 20246, 'Opp', 111 UNION ALL
SELECT 20250, 'Godk', 111 UNION ALL
SELECT 111450, 'Reg', 222 UNION ALL
SELECT 140080, 'Inn', 222 UNION ALL
SELECT 202460, 'Opp', 222 UNION ALL
SELECT 202500, 'Godk', 222
)
SELECT
ID,
Name,
TID
FROM Activity a1
WHERE
(SELECT a2.Name FROM Activity a2
WHERE a1.TID = a2.TID AND
a2.ID > a1.ID
ORDER BY a2.ID
LIMIT 1) = 'Godk';
| ID | Name | TID |
|---|---|---|
| 20246 | Opp | 111 |
| 202460 | Opp | 222 |