How to find if difference between all row data for a specific columns are same
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