How to find if difference between all row data for a specific columns are same I have a table with column with following data,

Column1
0.50
1.00
1.50
2.00
2.50
....
10000.00


Is there a way to validate the pattern that each data row has a difference of 0.50 ?

I tried googling but even struggling with keywords

I want to achieve is that, I want to make sure no value between 1 and 10000 is missing, e.g. I want to know if 100,00 is missing or 9999.50 is missing. I am not even sure if it's achievable?
validate the pattern that each data row has a difference of 0.50


For example, look at

WITH cte AS ( SELECT Column1 - COALESCE(LEAD(Column1) OVER (ORDER BY Column1), 0) delta
              FROM table )
SELECT delta, COUNT(delta)
FROM cte
GROUP BY delta