SELECT buyer_name, buyer_id, organization_id, sr_instance_id, plan_id FROM msc_system_items WHERE buyer_id IS NOT NULL GROUP BY organization_id, sr_instance_id, plan_id, buyer_name, buyer_id
View Text - HTML Formatted
SELECT BUYER_NAME , BUYER_ID , ORGANIZATION_ID , SR_INSTANCE_ID , PLAN_ID FROM MSC_SYSTEM_ITEMS WHERE BUYER_ID IS NOT NULL GROUP BY ORGANIZATION_ID , SR_INSTANCE_ID , PLAN_ID , BUYER_NAME , BUYER_ID