I am very new to T-SQL.. and i came across this:
ROW_NUMBER ( )
OVER ( [ PARTITION BY value_expression , ... [ n ] ] order_by_clause )
Can someone explain to me how this works, its purpose and when do we usually use it for?
Am i asking for knowledge and i am very confident some1 from this excellent forum explain this well.