Re: sql order but move some rows bottom [message #182407 is a reply to message #182406] |
Sat, 03 August 2013 16:31 |
Luuk
Messages: 329 Registered: September 2010
Karma:
|
Senior Member |
|
|
On 03-08-2013 18:10, nawfer wrote:
> Il Sat, 03 Aug 2013 12:53:00 +0200, Luuk ha scritto:
>
>> On 03-08-2013 12:44, nawfer wrote:
>>> I would like to order a list; sorted by column 1,
>>> but when the elements have the value 100,
>>> move them at the end of the list
>>>
>> ORDER BY (column2 = 100) ASC, column1 ASC, column2 ASC
>> ?
>
> but if want also to verified the 3 colum (send bottom also the y) ?
ORDER BY (column2 = 100 or column3='Y') ASC, column1 ASC, column2 ASC
|
|
|