Nomor Urut SQL

Cara membuat nomor urut SQL, syntax

select  ROW_NUMBER() OVER (ORDER BY nama_kolom ASC) AS NOMOR  from nama_tabel

Contoh :
select ROW_NUMBER() OVER ( ORDER BY emp_id ASC) AS NOMOR from employe