排序动态sql

<!-- 排序动态脚本 -->
	<sql id="OrderByInfo">
        order by
        <choose>
            <when test="orderBy !=null and orderBy !=''">
                ${orderBy}
                <choose>
                    <when test="sortName !=null and sortName !=''">
                        ${sortName}
                    </when>
                    <otherwise> DESC</otherwise>
                </choose>
            </when>
            <otherwise>
                GXSJ DESC
            </otherwise>
        </choose>
    </sql>