select lotsn from lot order by lotsn 正确
select lotsn from (select lotsn from lot order by Lotsn ) lotsn_A union all
select lotsn from (select lotsn from lot order by Lotsn ) lotsn_B是错误的
但是我在视图里新建两个视图一个是Lotsn_C,Lotsn_D
然后使用
select lotsn from Lotsn_C union all
select lotsn from lotsn_D 是正确的我想按下面的格式输出
000000001
000000002
000000003
000000004
000000001
000000002
000000003
000000004
的方式,每组都是从小到大的排序
如果采用
select lotsn from lot union all
select lotsn from lot order by lotsn 是正确的
但得到的结果是
000000001
000000001
000000002
000000002
000000003
000000003
000000004
000000004
达不到我的要求
如何将
select lotsn from Lotsn_C union all
select lotsn from lotsn_D
能用一句话写出来啊.其中上面的lotsn_C是视图,前面有提过我的目的是先排了序然后输出两次.
谢谢!
select lotsn from (select lotsn from lot order by Lotsn ) lotsn_A union all
select lotsn from (select lotsn from lot order by Lotsn ) lotsn_B是错误的
但是我在视图里新建两个视图一个是Lotsn_C,Lotsn_D
然后使用
select lotsn from Lotsn_C union all
select lotsn from lotsn_D 是正确的我想按下面的格式输出
000000001
000000002
000000003
000000004
000000001
000000002
000000003
000000004
的方式,每组都是从小到大的排序
如果采用
select lotsn from lot union all
select lotsn from lot order by lotsn 是正确的
但得到的结果是
000000001
000000001
000000002
000000002
000000003
000000003
000000004
000000004
达不到我的要求
如何将
select lotsn from Lotsn_C union all
select lotsn from lotsn_D
能用一句话写出来啊.其中上面的lotsn_C是视图,前面有提过我的目的是先排了序然后输出两次.
谢谢!
解决方案 »
- 如果用sql语句执行,把一个表的name1字段自动写入另一个表的name2字段
- 怎样从sql 2000中导出含有数据的sql语句?
- 想知道一个表中列的类型
- 求解释xml数据类型提供的value方法!!!!
- 简单问题:OpenDataSource问题????急,在线等!!!!!!!!!!!
- [求助]如何如何将列更新从一个表传递到另一个表
- SQL 语句优化 求助大侠
- 交易表的存储问题
- SQL SERVER 2005登录时出现的问题(见图),求解决之道
- sqlserver2000的执行效率与内存的大小有关系吗??
- Sql server 2005 修改列顺序问题,在百度难倒一遍,不知道在CSDN是不是也一样.兄弟姐妹们,救命啊!
- 求一条SQL,麻烦帮帮忙,3Q,一对多查询
declare @tb table (lotsn varchar(5))
insert into @tb values('00001')
insert into @tb values('00002')
insert into @tb values('00005')
insert into @tb values('00004')
insert into @tb values('00003')select lotsn from (select top 4294967295 * from @tb order by lotsn asc) tb_a
union all
select lotsn from (select top 4294967295 * from @tb order by lotsn asc) tb_b
insert into @tb values('00001')
insert into @tb values('00002')
insert into @tb values('00005')
insert into @tb values('00004')
insert into @tb values('00003')--select lotsn from (select lotsn from @tb order by lotsn asc) tb_a
--union all
--select lotsn from (select lotsn from @tb order by lotsn asc) tb_bSELECT LOTSN FROM (
SELECT LOTSN,'1' ID FROM @tb
UNION ALL
SELECT LOTSN,'2' ID FROM @tb )A ORDER BY ID, LOTSN