SQL 编号登录并创建 SQL 查询

Question

>我有以下数据

Column
1
0
1
0
1
0
1
1
0
1
1
0
0
0

我需要下面的 o/p

1
1
1
0
0
1
1
0
0
1
0

Answer 1

在SQL Server中，你可以做这样的事情。

SELECT IIF(id = 0, 1, 0) AS col1
FROM   (SELECT id,
               Row_number() OVER( ORDER BY (SELECT NULL)) AS rn
        FROM   tablename) tmp
ORDER  BY rn DESC  

结果

+------+
| col1 |
+------+
|    1 |
|    1 |
|    1 |
|    0 |
|    0 |
|    1 |
|    0 |
|    0 |
|    1 |
|    0 |
|    1 |
|    0 |
|    1 |
|    0 |
+------+