The ROW_NUMBER clause in Oracle SQL / PLSQL is basically a windowing clause and is used to assign a unique row number to fetched records based on an ordered list. ROW_NUMBER clause starts numbering from 1. ROW_NUMBER clause can be used with and without PARTITION BY clause. Syntax for using the ROW_NUMBER clause without PARTITION […]