I have a query that has the following fields. There are approximately 5 million rows in this table. My goal is to reduce the amount of rates loaded into our mainframe system by condensing the tables to smaller sizes. Thus my extract was originally all weight breaks for each table. I have narrowed it down to the min breaks for each table where the rate value changes. I now need to identify the unique record sets of weight profiles (breaks) so that they can be created. I am unsure of how to obtain all unique sets. Some tables could have the same breaks or not... Below does not however there are tables that do have all breaks the same...




Ptr_RateTable, MinOfWeight_Up_To,

Example data for these fields would be
Min_WeightProfilePtr_RateTableMinOfWeight_Up_To1109LW01811109LW01821109LW01861109LW018111109LW018211109LW018261109LW018511109LW018711109LW0181011109LW01911109LW01921109LW01931109LW01961109LW019111109LW019311109LW019411109LW0191011109LW0191511109LW02011109LW02021109LW02061109LW020111109LW0201011109LW0201281109LW0201291109LW02111109LW02121109LW02131109LW021111109LW021361109LW021411109LW021151


Any help is greatly appreciated

Thank you