SELECT
-------------------- ---------- -----------
UNION ALL SELECT '赵六', 90
(5 行受影响)
3> go
CREATE VIEW tmp_view AS
1 李四 80
2> select * from test_delete;

---------- -----------
1> DELETE FROM tmp_view WHERE no != 1
赵六 70
test_delete
name,
UNION ALL SELECT '李四', 80

复制代码 代码如下:

复制代码 代码如下:

李四 80
-- 张三100 与 王五80 是有重复的
赵六 90
1 赵六 90
--删除数据
1>
ROW_NUMBER() OVER (PARTITION BY name, value ORDER BY (SELECT 1) ) AS no,
INSERT INTO test_delete

UNION ALL SELECT '王五', 80
--创建视图
张三 100

name value
UNION ALL SELECT '王五', 80
FROM
SELECT '张三', 100
-- 测试检索数据

-- 任意的测试表

no name value
UNION ALL SELECT '赵六', 70

ROW_NUMBER() OVER (PARTITION BY name, value ORDER BY (SELECT 1) ) AS no,
作者 tearsmo name,
value INT
1 王五 80
value
1 张三 100


(2 行受影响)
-- 核对结果

test_delete
CREATE TABLE test_delete(
SELECT