jxycms
8/31/2017 - 7:40 AM

make custom select option be the first row

make custom select option be the first row

select 
	'Select Option' as id, '--Select Option--' as value, 0 as count
union 
SELECT distinct iam as id,iam as value, DENSE_RANK() OVER(ORDER BY iam)  as count
FROM customtable_newsletterlookup
order by count