Industries

SELECT 
    eprtrSectorNameLabel as opt_key,
    eprtrSectorNameLabel as opt_value,
    eprtrSectorName as opt_text
FROM [IED].[latest].[EPRTR_sectors]
GROUP BY eprtrSectorNameLabel, eprtrSectorName
ORDER BY opt_text