select * from (SELECT user_id, user_nm FROM m_x_user where user_nm is not null order by user_nm DESC) as temp1 union allselect * from ( SELECT user_id, user_nm FROM m_x_user where user_nm = '001' order by user_nm ) as temp2
select * from m_x_user where user_nm is not null union select * from m_x_user where user_nm is null
(SELECT user_id, user_nm
FROM m_x_user
where user_nm is not null
order by user_nm DESC) as temp1
union allselect * from
(
SELECT user_id, user_nm
FROM m_x_user
where user_nm = '001'
order by user_nm )
as temp2
where user_nm is not null
union
select * from m_x_user
where user_nm is null
这样简单的写,也可以吧???