LookupOrderedRows in AMPScript: Retrieve and Sort Related Data

An optimized AMPScript pattern using LookupOrderedRows to retrieve, sort, and limit related records (like transaction history) from a Data Extension. This prevents OMM timeouts by handling sorting at the database level rather than the script level.