select A.value,B.value,C.value,D.value,E.value
into tmp
from
(select value from @t where value<=6) A,
(select value from @t where value<=7) B,
(select value from @t where value<=8) C,
(select value from @t where value<=9) D,
@t E
where A.value<B.value
and B.value<C.value
and C.value<D.value
and D.value<E.value
select * from tmp
into tmp
from
(select value from @t where value<=6) A,
(select value from @t where value<=7) B,
(select value from @t where value<=8) C,
(select value from @t where value<=9) D,
@t E
where A.value<B.value
and B.value<C.value
and C.value<D.value
and D.value<E.value
select * from tmp
解决方案 »
- SQL实现一个功能 自动删除存在数据库中超过一定时间的数据。 不甚感激!!!
- 触发器
- 登录名属性的服务器角色有八个,请帮忙说出每一个的功能,谢谢!
- 求一sql语句,把数据库里面的内容显示为如下格式
- 求sql语句(只要相同记录有两条以上,就将这两条或多条相同记录全部删除)???
- 有没有工具可以根据数据库的表结构生成procedure和.net两层的数据访问的代码?
- 一个简单查询的问题-----初学者问
- 数据库多字段重复检测
- MS SQL Server2000企业版和个人版有什么区别?
- 生成sql脚本的语句怎么写
- 又一个将这些数据存到表中,呵呵
- sql 的 borrows 表和 readers 的借书 与还书问题,大家来帮帮我!
insert into @t select 1
insert into @t select 2
insert into @t select 3
insert into @t select 4
insert into @t select 5
insert into @t select 6
insert into @t select 7
insert into @t select 8
insert into @t select 9
insert into @t select 10select A.value as v1,B.value as v2,C.value as v3,D.value as v4,E.value as v5 into tb1
from
(select value from @t where value<=6) A,
(select value from @t where value<=7) B,
(select value from @t where value<=8) C,
(select value from @t where value<=9) D,
@t E
where A.value<B.value
and B.value<C.value
and C.value<D.value
and D.value<E.valuego
select * from tb1
/*
v1 v2 v3 v4 v5
----------- ----------- ----------- ----------- -----------
1 2 3 4 5
1 2 3 4 6
1 2 3 4 7
1 2 3 4 8
1 2 3 4 9
......*/
insert into ss(a,b,c,d,e,f)
select A.value as v1,B.value as v2,C.value as v3,D.value as v4,E.value as v5
from
(select value from @t where value<=6) A,
(select value from @t where value<=7) B,
(select value from @t where value<=8) C,
(select value from @t where value<=9) D,
@t E
where A.value<B.value
and B.value<C.value
and C.value<D.value
and D.value<E.value
select A.value as v1,B.value as v2,C.value as v3,D.value as v4,E.value as v5
from
(select value from @t where value <=6) A,
(select value from @t where value <=7) B,
(select value from @t where value <=8) C,
(select value from @t where value <=9) D,
@t E
where A.value <B.value
and B.value <C.value
and C.value <D.value
and D.value <E.value
1 select * into table2 from table1 where .....
2 insert into table2 select * from table1 where ......