The task: Select the Top 2 products based on INVOICE_AMOUNT for every LOCATION without using OLAP functions like ROW_NUMBER() as our DBA does not allow this.
DB2 Z/OS 8.1
Data:
Code:
SUPPLIER LOCATION PRODUCT INVOICE_AMOUNT JJ FOODS FLORIDA TOMATO 56.67 BE FOODS PHILADELPHIA BACON 46.40