how to get unique row

[sonal]

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

Thanks

[Scrowler]

mysql code >>

SELECT DISTINCT ColumnName FROM Table WHERE ColumnName = Value

the DISTINCT identifier selects only unique records