所以,我有这个:
select ticket_trackingno, ticket_title, ticket_priority_id, ticket_status_id
from hd_tickets
where ticket_priority_id <> 'None'
and ticket_status_id = 'Assigned'
order by ticket_priority_id desc
这样,我的 Ticket_priority_id 列就会按中、低、高排序。我想要的是低、中、高。我想知道我该如何去做呢?
ORDER BY CASE ticket_priority_id
WHEN 'low' THEN 1
WHEN 'med' THEN 2
WHEN 'high' THEN 3 END
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)