SQL Custom Sort By

Question

Let's say I have this in a column:

'a'
'b'
'c'
'd'
'e'

I want the data to be sorted and looked like this:

'a'
'b'
'd'
'e'
'c'

Is this possible?

Add a new column with order number which generating by your rules. No other method. — MatrixTXT
– MatrixTXT, Commented Sep 14, 2018 at 2:50
What is the logic for this ordering? See the above comment as well. — Tim Biegeleisen
– Tim Biegeleisen, Commented Sep 14, 2018 at 2:55
I have some data where for nothing other than cosmetic purposes, I wanted one particular row above every other row, that was it. — Chicken Sandwich No Pickles
– Chicken Sandwich No Pickles, Commented Sep 14, 2018 at 3:21

Xedni · Accepted Answer · 2018-09-14 02:56:55Z

2

select letter
from letters
order by
   case letter
     when 'a' then 0
     when 'b' then 1
     when 'd' then 2
     when 'e' then 3
     when 'c' then 4
   end

answered Sep 14, 2018 at 2:56

Xedni

4,7913 gold badges22 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

MatrixTXT Over a year ago

This is just the ans from stackoverflow.com/questions/19196475/….

Ullas · Accepted Answer · 2018-09-14 04:57:59Z

2

An other way around using CASE statement is,

Query

select [column_name] 
from [your_table_name]
order by 
  case [column_name] 
  when 'c' then 2 
  else 1 end, 
[column_name];

Find a demo here

answered Sep 14, 2018 at 4:57

Ullas

11.6k5 gold badges36 silver badges52 bronze badges

Collectives™ on Stack Overflow

SQL Custom Sort By

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related