34,576
社区成员
发帖
与我相关
我的任务
分享
CREATE TABLE [dbo].[ZHOU](
[A] [int] NULL,
[B] [int] NULL
)
INSERT INTO ZHOU
SELECT 1,0
UNION
SELECT 0,3
UNION
SELECT 5,0
UNION
SELECT 0,2
SELECT
BB.*
FROM
(
SELECT
AA
FROM
(
SELECT A AS AA FROM ZHOU WHERE A<>0
UNION
SELECT B AS AA FROM ZHOU WHERE B<>0
) AS T
) AS TT , ZHOU AS BB
WHERE
TT.AA=BB.A OR TT.AA=BB.B
ORDER BY TT.AA
我自己写的有点复杂
SELECT *
FROM zhou
ORDER BY A+B ASC
/*
A B
1 0
0 2
0 3
5 0*/