SQL Server 2017 (Linux)

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

select version();
Msg 195 Level 15 State 10 Line 1
'version' is not a recognized built-in function name.

CREATE TABLE test 
(
  id INTEGER, 
  next_id INTEGER NOT NULL
);
INSERT INTO test (ID,	Next_ID) VALUES
(1,	3),
(2,	3),
(3,	6),
(4,	5),
(5,	6),
(6,	8),
(7,	10),
(8,	9);
8 rows affected

WITH  RECURSIVE cte (id_, cte_) AS
(
  SELECT 1, 3 
  UNION ALL
  SELECT 
    c.next_id_, t.next_id
  FROM
    cte c
  JOIN test t
  ON c.next_id_ = t.id
)
SELECT * FROM cte;
Msg 102 Level 15 State 1 Line 1
Incorrect syntax near 'cte'.