Wednesday, February 25, 2015

Unsorted list of result

>> I had comment the "order by" command but I obtain a sorted list result ... why?


Without Order By clause, there is no guarantee of ANY order.


>> I'd like an unsorted list.. The my order must be this


Use below as ORDER BY clause and try:



order by (case when TSName = 'Rated power' then 1
when TSName = 'Amperage at voltage 230 V' then 2
when TSName = 'Battery capacity' then 3
when TSName = 'No-load speed' then 4
when TSName = 'Max. Ø of rubber plate' then 5
end) asc





-Vaibhav Chaudhari





No comments:

Post a Comment