Here is a complete answer based on the provided specification:

Limiting Records from a SQL View: A Guide to OFFSET FETCH Clauses

Merging Multiple Result Rows After STRING_SPLIT On Left Join: A SQL Query Scenario

Extracting Specific Elements from an XML Document using XQuery in SQL Server 2005 or Later

Using ANSI/ISO SQL for Alternatives to TOP 1 WITH TIES in Third-Party Programs

Selecting One Row Per Identifier with Shortest Overall Path Length in T-SQL

Understanding and Implementing Custom IP Addresses in SQL Server UDDTs

Transforming Data with PIVOT: A Step-by-Step Guide to Selecting Multiple Rows into Columns in SQL Server

Understanding the Risks of Datatype Conversion Errors in SQL Queries

Identifying Rows with Duplicate Column Values in SQL Using Group By Clause and Its Variations.