Assign Rank to SELECT List

Assign Rank to SELECT List

SELECT
Rank = (
SELECT
COUNT(DISTINCT T2.ColumnName)
FROM
dbo.TableName AS T2
WHERE
[Some Where Clause]
AND T2.ColumnName <= T.ColumnName) ----- REQUIRED!
, [Column List]
FROM
dbo.TableName AS T
WHERE
[Some Where Clause]
ORDER BY
Rank