代码如下:
--表的行操作
--union并
--interrect交
--except差
use DBTEST
select * from sf1
select * into test11 from sf1
select * into test111 from test11 where pr='软件2104'
select * into test112 from test11 where pr='软件2105'
select * from test111 union select * from test112
select * from test111 intersect select * from test112
select * from test111 except select * from test112