sql语句怎么倒序啊！大神们

[nanlinghua]

怎么让下面的sql语句查出的数据倒序排列
<select id="getUserById" resultType="user" parameterType="user" >
select * from M_JOB order by f_b_member_id desc where 1=1
<if test= "f_b_member_id!=null">
AND f_b_member_id between #{f_b_member_id} and #{f_b_member_id1}
</if>
<if test="f_b_mem_company_name!=null">
AND f_b_mem_company_name like #{f_b_mem_company_name}
</if>
<if test="f_job_title!=null">
AND f_job_title like %#{f_job_title}%
</if>
<if test="f_occpation!=null">
AND f_occpation=#{f_occpation}
</if>
<if test="f_w_pref!=null">
AND f_w_pref=#{f_w_pref}
</if>
<if test="f_w_address1!=null">
AND f_w_address1 like %#{f_w_address1}%
</if>
<if test="f_w_address2!=null">
AND f_w_address2 like %#{ f_w_address2}%
</if>
<if test="f_employment!=null">
AND f_employment=#{f_employment}
</if>
</select>

[wula0010]

order by columnname asc从小到大排序，order by columnname desc，从大到小排序

[jfhgkdk]

select * from M_JOB order by f_b_member_id desc where 1=1 这一句 order by f_b_member_id desc 这个应该是放到where后面的吧