SELECT
gx.id,
gx.gg_xxzx_ywid,
gx.gg_xxzx_rwlx,
gx.gg_xxzx_rwdh,
gx.gg_xxzx_rwtxbj,
gx.gg_xxzx_jjrwbz,
gx.create_by,
gx.create_time,
gx.update_time,
FROM
gg_xxzx gx UNION ALL
SELECT
gx.id,
gx.gg_xxzx_ywid,
gx.gg_xxzx_rwlx,
gx.gg_xxzx_rwdh,
gx.gg_xxzx_rwtxbj,
gx.gg_xxzx_jjrwbz,
gx.create_by,
gx.create_time,
gx.update_time,
FROM
gg_xxzx gx
LIMIT ?
ORDER BY
gg_xxzx_rwtxbj ASC,
create_time DESC
这是解析后的SQL
orderby放在xml里放在外边最后的解析结果都是LIMIT ? ORDER BY gg_xxzx_rwtxbj ASC, create_time DESC