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
),
cte AS (
SELECT ID, Name, TID,
LEAD(Name, 1) OVER (PARTITION BY TID ORDER BY ID) AS lead_name
FROM Activity
)
SELECT ID, Name, TID
FROM cte
WHERE lead_name = 'Godk';
| ID | Name | TID |
|---|---|---|
| 20246 | Opp | 111 |
| 202460 | Opp | 222 |