CUSTOMIZE ORDERING IN SQL

Question

select CategoryName
from Category where CatId IN (55,568,5412,8991,928,3213,142,9250,12330,2983)

I WANT RECORD TO BE RETRIVE IN SAME ORDER AS (55,568,5412,8991,928,3213,142,9250,12330,2983)
BUT I AM GETTING SOME ANOTHER RANDOM ORDER

Amol · Answer

i got it select * from ProductGroups where GroupID in (241271465) order by case GroupId when 7 then 1 -- First in ordering when 14 then 2 -- Second else 3 end

Manikavelu Velayutham · Answer

Correct If there is any indexed column in that table it would retrieve the values in that order only. You have to implement a new logic here to retrieve it in same order as you specified above.