Dear all,
What SELECT is the best for this sorting problem?
table mytable:
No | Name | ID
1 | aaa | 20
2 | bbb | 90
3 | ccc | 80
4 | ddd | 10
I would like to sort become like this :
Sort from name, but ID 90 will be the last. So it will be like this:
No | Name | ID
1 | aaa | 20
3 | ccc | 80
4 | ddd | 10
2 | bbb | 90
What I know to sort name with:
select * from mytable order by name.....
what next? or any other advice?
Thank you in advance.
What SELECT is the best for this sorting problem?
table mytable:
No | Name | ID
1 | aaa | 20
2 | bbb | 90
3 | ccc | 80
4 | ddd | 10
I would like to sort become like this :
Sort from name, but ID 90 will be the last. So it will be like this:
No | Name | ID
1 | aaa | 20
3 | ccc | 80
4 | ddd | 10
2 | bbb | 90
What I know to sort name with:
select * from mytable order by name.....
what next? or any other advice?
Thank you in advance.