Browse DevX
Sign up for e-mail newsletters from DevX

Tip of the Day
Language: SQL
Expertise: Intermediate
Jan 27, 2004



Building the Right Environment to Support AI, Machine Learning and Deep Learning

Dynamically Create a Sortable Column

Sometimes you need your resultset sorted a particular way and using the primary key doesn't accomplish what you need. One way to get around this is to create a sortable column dynamically in your query using the CASE function.

SELECT name, title, priority =
(CASE title
when 'President' then 1 when 'Vice President' then 2 when
'Secretary' then 3
when 'Treasurer' then 4
FROM executive
ORDER BY priority
In this example, I give each title a priority and sort by it. This could have been accomplished using a second table and joining to it but why do that if you don't need to?
Ian Lane
Comment and Contribute






(Maximum characters: 1200). You have 1200 characters left.



Thanks for your registration, follow us on our social networks to keep up-to-date