MySQL中使用union all获得并集的排序
标签：title status ram release 情况 思路 enabled 存储 col
MySQL中使用union all获得并集的排序
PROMOTE_ID,
SEQUENCE_ID,
PROMOTE_STATUS,
PROMOTE_TITLE,
RELEASE_DATE
FROM (
(SELECT
PROMOTE_ID,
SEQUENCE_ID,
PROMOTE_STATUS,
PROMOTE_TITLE,
RELEASE_DATE
FROM SYS_TEXT_PROMOTE
WHERE
ENABLED_FLAG = ‘1‘
AND PROMOTE_STATUS=1
AND SORT_ID = #{params.sortId}
order by SEQUENCE_ID DESC,LAST_UPDATE_DATE DESC) a)
union all
select
PROMOTE_ID,
SEQUENCE_ID,
PROMOTE_STATUS,
PROMOTE_TITLE,
RELEASE_DATE
FROM (
(SELECT
PROMOTE_ID,
SEQUENCE_ID,
PROMOTE_STATUS,
PROMOTE_TITLE,
RELEASE_DATE
FROM SYS_TEXT_PROMOTE
WHERE
ENABLED_FLAG = ‘1‘
AND PROMOTE_STATUS=2
AND SORT_ID = #{params.sortId}
order by RELEASE_DATE DESC,LAST_UPDATE_DATE DESC) b)
union all
select
PROMOTE_ID,
SEQUENCE_ID,
PROMOTE_STATUS,
PROMOTE_TITLE,
RELEASE_DATE
FROM (
(SELECT
PROMOTE_ID,
SEQUENCE_ID,
PROMOTE_STATUS,
PROMOTE_TITLE,
RELEASE_DATE
FROM SYS_TEXT_PROMOTE
WHERE
ENABLED_FLAG = ‘1‘
AND PROMOTE_STATUS=0
AND SORT_ID = #{params.sortId}
order by RELEASE_DATE DESC,LAST_UPDATE_DATE DESC) c)