I have a small problem with the order of a database where I use ORDER BY ASC and you show me the results backwards.
I share the code and I leave an image:
select 'Seleccione...' as analisis union (SELECT DISTINCT analisis
FROM ensayos WHERE laboratorio LIKE '%LET-SA%'
AND matriz LIKE '%Agua de Mar%'
ORDER BY analisis ASC)
union select 'Otros' as analisis union select 'No Aplica' as analisis
being that it should look like this:
