This function will assign the unique Id to each row of result. Please see the result in above image. ROW_NUMBER() has assigned unique Id to each record This function works in same way as ROW_NUMBER() ...

Row_number()this function is used to assign a unique id to each row returned by the sql query fired.rank()this function is similar torow_number() with the only difference itleaves a gap between the ...