How to get every nth row value in sql

I have a select statement in sql:

SELECT DISTINCT [Year] FROM [data_list] ORDER BY [YEAR] ASC;

​x
 
SELECT DISTINCT [Year] FROM [data_list] ORDER BY [YEAR] ASC;​

Result:

 
Year----2019202020212022202320242025202620272028​

I want list of year in 3 increments. For example:

Year
----
2019
2022
2025
2028

 
Year----2019202220252028​

Answer

You can use ROW_NUMBER:

SELECT [Year] 
FROM (
  SELECT [Year], ROW_NUMBER() OVER (ORDER BY [Year] ASC) rn 
  FROM table_name
  GROUP BY [YEAR]
) t WHERE (t.rn - 1) % 3 = 0

 
SELECT [Year] FROM (  SELECT [Year], ROW_NUMBER() OVER (ORDER BY [Year] ASC) rn   FROM table_name  GROUP BY [YEAR]) t WHERE (t.rn - 1) % 3 = 0​