62,612
社区成员
发帖
与我相关
我的任务
分享
(select NOTICE_ID,NOTICE_ORDER
from NOTICE
where NOTICE_ORDER is not null AND NOTICE_ORDER<>''
ORDER BY NOTICE_ORDER ASC
)
union all
(select NOTICE_ID,NOTICE_ORDER
from NOTICE
where NOTICE_ORDER is null OR NOTICE_ORDER=''
ORDER BY NOTICE_ID DESC
)
select NOTICE_ID ,NOTICE_ORDER from
(
(select * from
(
select * from NOTICE where NOTICE_ORDER is not null AND NOTICE_ORDER<>''
order by NOTICE_ORDER ) as a
)
union all
(select * from
(
select * from NOTICE where NOTICE_ORDER is null OR NOTICE_ORDER=''
order by NOTICE_ID desc ) as b
)
) as c;
select NOTICE_ID ,NOTICE_ORDER from
(
(select * from NOTICE
where NOTICE_ORDER is not null AND NOTICE_ORDER<>''
order by NOTICE_ORDER )
union all
(select * from
(
select * from NOTICE where NOTICE_ORDER is null OR NOTICE_ORDER=''
order by NOTICE_ID desc ) as A
)
) as B
(select NOTICE_ID,NOTICE_ORDER
from NOTICE
where NOTICE_ORDER is not null AND NOTICE_ORDER<>''
ORDER BY NOTICE_ORDER
)
union all
(select NOTICE_ID,NOTICE_ORDER
from NOTICE
where NOTICE_ORDER is null OR NOTICE_ORDER=''
ORDER BY NOTICE_ID DESC
)
ORDER BY NOTICE_ORDER DESC