>> 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