how to get unique row

:confused:
How to get unique row indentifer in SQL-server. As we can find
by rownum and rowid in oracle.

Thanks

mysql code >>

SELECT DISTINCT ColumnName FROM Table WHERE ColumnName = Value

the DISTINCT identifier selects only unique records