SELECT category_name, description, organization_id, sr_instance_id, category_set_id FROM msc_item_categories GROUP BY organization_id, sr_instance_id, category_set_id, category_name, description
View Text - HTML Formatted
SELECT CATEGORY_NAME , DESCRIPTION , ORGANIZATION_ID , SR_INSTANCE_ID , CATEGORY_SET_ID FROM MSC_ITEM_CATEGORIES GROUP BY ORGANIZATION_ID , SR_INSTANCE_ID , CATEGORY_SET_ID , CATEGORY_NAME , DESCRIPTION