How to Add a New Column with Incrementing Integer Values for Duplicate Names in SQL

Optimizing SQL Queries to Retrieve Maximum Salary per Department

Fetching Last Numeric Value with REGEXP SUBSTR in Oracle SQL