Selecting a Single Row Per Unique ID: A Comprehensive Approach for IBM Netezza and Aginity Workbench