Re: sql order but move some rows bottom [message #182425 is a reply to message #182407] |
Sun, 04 August 2013 11:50 |
nawfer
Messages: 34 Registered: August 2011
Karma:
|
Member |
|
|
>>> 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
ok very very much thanks
Your last touch to perfection
I changed to better explain the first column; instead of letters I used
numbers
after sort I have
1
1
2
3
3
4
4
5
5
6
7
8
1 100
1 100
2 y
4 y
5 y
5 100
7 100
ok 100 and y are bottom; but are mixed, or better they are ordered (col 1)
is possible have separated ? y first or after 100
example y first of 100
6
7
8
2 y
4 y
5 y
1 100
1 100
5 100
7 100
____
other last two questions in sql is better use OR or || or is same?
and col01 <= col02
in this case
col01 col02
null or void filed <= 10
I noticed that condition isn't verified (for me ok if so) but is always so
for sql? col 01 if haven't a value isn't considered minor of a number?
|
|
|