Is this what you are looking for?
select row_number() over (partition by rand() order by rand() )  From <table_name>