(Josef Richberg) There have been numerous occasions where I have to pick a one of two records out of a given result set, but how I determine which one has some unique rules. I have two examples of this and I show how I used Row_Number() to solve this.
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help