for mysql 4.1:mysql> select id,name,sort from t41 where sort=0 group by sort union select id,n
ame,sort from t41 where sort>0 order by sort;
+------+------+------+
| id | name | sort |
+------+------+------+
| 7 | dd | 0 |
| 6 | ww | 1 |
| 45 | rr | 2 |
| 14 | bb | 3 |
| 3 | aa | 5 |
+------+------+------+
5 rows in set (0.00 sec)
ame,sort from t41 where sort>0 order by sort;
+------+------+------+
| id | name | sort |
+------+------+------+
| 7 | dd | 0 |
| 6 | ww | 1 |
| 45 | rr | 2 |
| 14 | bb | 3 |
| 3 | aa | 5 |
+------+------+------+
5 rows in set (0.00 sec)
union你用得挺熟练的嘛!
select * from table1 group by sort order by sort
select * from table1 group by sort order by sort如果楼主的sort在>0的情况下有重复的(比如有两个3 ),这个会只显示一个而楼主只说sort=0时显示一条所以我在2楼问他>0的是否会有重复
union
select id,name,sort from t41 where sort > 0 order by sort