If you provide DDL and sample data, we can probably help you out. Your Row_number function is partitioning by OrdNo and DocName, so you won't get 1 record per OrdNo, but you'll get 1 record per OrdNo and DocName
2 Likes