| Re: sql order but move some rows bottom [message #182444 is a reply to message #182441] |
Sun, 04 August 2013 17:53   |
nawfer
Messages: 34
Registered: August 2011
Karma:
|
Member |
|
|
Il Sun, 04 Aug 2013 19:37:32 +0200, Luuk ha scritto:
> On 04-08-2013 17:49, nawfer wrote:
>>> y before 100:
>>> ORDER BY
>>> (CASE WHEN column2 = 100 THEN 2 ELSE 0 END + CASE WHEN column3='Y' THEN
>>> 1 ELSE 0 END) ASC, column1 ASC, column2 ASC
>>
>> small curiosity
>> the above code respect at a simple order
>>
>> ORDER BY column1 ASC, column2 ASC
>>
>>
>> change the performance (example - 5%)or is insignificant the difference?
>>
>
>
> Sorry, my English is not good enough to understand what you mean .....
> Could you rephrase the question?
I ask if the code you post me for does order taht is more complex than a
simple order by make slow the query ; is more slow of 5% 10% or more?
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]