Ò»¸ö±íA id name password 1 aa ccc 2 bb eee 3 hh mmm
ÈçºÎÄÜÏÔʾ³ÉÒ»ÐпÕÒ»ÐÐ 1 aa ccc
2 bb eee
3 hh mmm
»¹ÓÐÄܲ»ÄÜÏÔʾΪһÐпÕÒ»ÐУ¬ÁÐÒ²Ò»ÐпÕÒ»ÐÐ 1 ¿Õ aa ¿Õ ccc
2 bb eee
3 hh mmm
ÇóÖúÏ´ó¼Ò ÔÎ ÕâÑùµÄÐèÇó ÁÐÓ¦¸Ã¿ÉÒÔ¼Ó¿Õ¸ñ ÐÐÔõô¸ãµÈ¸ßÈË µ¹£¬Õâ¸öÔÚ³ÌÐòÖÐÈ¥²¼¾ÖÑùʽ¾ÍÐÐÁË¡£ ¸ÉÂïʲô¹¦Äܶ¼ÈÃÊý¾Ý¿âÀ´´¦Àí£¿ ͬÒâ, ÕâÖÖÈËÊÇÀ´ÕÒ³éµÄ select id , name , password from ( select cast(id as varchar) id , name , password , px = id from a union all select '' , '' , '' , px = id from a ) t order by px , case when name = '' then 2 else 1 end