I need to add a 'all' company type in my result for a drop down list, however the order in which the "all" company is showing is at position 8 or 9 and I want 'all' to show up at position 0 in the result order.
this is what I have s far:
SELECT COM_ID, COM_SHORT_NAME FROM TBLCOMPANY
SELECT 0 AS COM_ID, 'ALL' AS COM_SHORT_NAME FROM DUAL
ORDER BY CASE 2 WHEN 'ALL' THEN 1 END ASC;