摘要：
--1. 创建表，添加测试数据CREATETABLE tb(id int, [value]varchar(10))INSERT tb SELECT1, 'aa'UNIONALLSELECT1, 'bb'UNIONALLSELECT2, 'aaa'UNIONALLSELECT2, 'bbb'UNIONALLSELECT2, 'ccc'--SELECT * FROM tb/**//*id value----------- ----------1 aa1 bb2 aaa2 bbb2 ccc(5 row(s) affect 阅读全文
