WITH RowNumbered AS (
    SELECT
        *,
        ROW_NUMBER() OVER (PARTITION BY your_column ORDER BY your_sort_column) AS row_num
    FROM
        your_table
)
SELECT *
FROM RowNumbered
WHERE row_num = 1;