3.3w+
社区成员
- 全部
- 基础类
- 应用实例
- 新技术前沿
怎么连接两个select语句
(select do.id, c.start_Time, c.ani, c.calling_Device, c.callee_Device, c.answer_Duration,
c.call_Type, c.ani_Area, c.undesktop_Notify_Missed_Call FROM Call_Master as c, Device_Info do
WHERE c.answer_Duration=0 AND do.apply_State=2 and c.call_Type in (1,3)
AND do.device = c.callee_Device and (do.device in ('8760') )
AND c.start_Time_Yy=2008 and c.start_Time_Mm=2 and c.start_Time_Dd=18
order by c.start_Time desc)
union
(
select di.id,b.start_Time, b.ani, b.calling_Device, b.callee_Device, b.answer_Duration,
b.call_Type, b.ani_Area, b.undesktop_Notify_Missed_Call FROM Call_detail as b, Device_Info di
WHERE b.answer_Duration=0 AND di.apply_State=2 and b.call_Type in (1,3)
AND di.device = c.callee_Device and (di.device in ('8760') )
AND b.start_Time_Yy=2008 and b.start_Time_Mm=2 and b.start_Time_Dd=18
order by b.start_Time desc
)
里面 call_mater 和 call_detail 表的结构是一样的
我想连接两个select 用Union 老是出错 应该改成什么样啊
c.call_Type, c.ani_Area, c.undesktop_Notify_Missed_Call FROM Call_Master as c, Device_Info do
WHERE c.answer_Duration=0 AND do.apply_State=2 and c.call_Type in (1,3)
AND do.device = c.callee_Device and (do.device in ('8760') )
AND c.start_Time_Yy=2008 and c.start_Time_Mm=2 and c.start_Time_Dd=18
order by c.start_Time desc)
union
(
select di.id,b.start_Time, b.ani, b.calling_Device, b.callee_Device, b.answer_Duration,
b.call_Type, b.ani_Area, b.undesktop_Notify_Missed_Call FROM Call_detail as b, Device_Info di
WHERE b.answer_Duration=0 AND di.apply_State=2 and b.call_Type in (1,3)
AND di.device = c.callee_Device and (di.device in ('8760') )
AND b.start_Time_Yy=2008 and b.start_Time_Mm=2 and b.start_Time_Dd=18
order by b.start_Time desc
)
里面 call_mater 和 call_detail 表的结构是一样的
我想连接两个select 用Union 老是出错 应该改成什么样啊
...全文
当前发帖距今超过3年，不再开放新的回复
发表回复
andrew_zx 2008-03-25
谢谢 熊，
ojuju10 你的这么写order by还是会出错的
ojuju10 你的这么写order by还是会出错的
ojuju10 2008-03-25
---加上top 100 percent
(select top 100 percent do.id, c.start_Time, c.ani, c.calling_Device, c.callee_Device, c.answer_Duration,
c.call_Type, c.ani_Area, c.undesktop_Notify_Missed_Call FROM Call_Master as c, Device_Info do
WHERE c.answer_Duration=0 AND do.apply_State=2 and c.call_Type in (1,3)
AND do.device = c.callee_Device and (do.device in ('8760') )
AND c.start_Time_Yy=2008 and c.start_Time_Mm=2 and c.start_Time_Dd=18
order by c.start_Time desc)
union
(
select top 100 percent di.id,b.start_Time, b.ani, b.calling_Device, b.callee_Device, b.answer_Duration,
b.call_Type, b.ani_Area, b.undesktop_Notify_Missed_Call FROM Call_detail as b, Device_Info di
WHERE b.answer_Duration=0 AND di.apply_State=2 and b.call_Type in (1,3)
AND di.device = c.callee_Device and (di.device in ('8760') )
AND b.start_Time_Yy=2008 and b.start_Time_Mm=2 and b.start_Time_Dd=18
order by b.start_Time desc
)
dobear_0922 2008-03-25
select do.id, c.start_Time as st, c.ani, c.calling_Device, c.callee_Device, c.answer_Duration,
c.call_Type, c.ani_Area, c.undesktop_Notify_Missed_Call
FROM Call_Master as c, Device_Info do
WHERE c.answer_Duration=0 AND do.apply_State=2 and c.call_Type in (1,3)
AND do.device = c.callee_Device and (do.device in ('8760') )
AND c.start_Time_Yy=2008 and c.start_Time_Mm=2 and c.start_Time_Dd=18
union
select di.id,b.start_Time as st, b.ani, b.calling_Device, b.callee_Device, b.answer_Duration,
b.call_Type, b.ani_Area, b.undesktop_Notify_Missed_Call
FROM Call_detail as b, Device_Info di
WHERE b.answer_Duration=0 AND di.apply_State=2 and b.call_Type in (1,3)
AND di.device = c.callee_Device and (di.device in ('8760') )
AND b.start_Time_Yy=2008 and b.start_Time_Mm=2 and b.start_Time_Dd=18
order by st desc
andrew_zx 2008-03-25
还是出错
消息 156，级别 15，状态 1，第 10 行
关键字 'order' 附近有语法错误。
消息 156，级别 15，状态 1，第 24 行
关键字 'order' 附近有语法错误。
难道union连接结果集除了结构列一样，有什么需要主要的吗
消息 156，级别 15，状态 1，第 10 行
关键字 'order' 附近有语法错误。
消息 156，级别 15，状态 1，第 24 行
关键字 'order' 附近有语法错误。
难道union连接结果集除了结构列一样，有什么需要主要的吗
wlinglong 2008-03-25
(select do.id as a, c.start_Time as b, c.ani as c, c.calling_Device as d, c.callee_Device as e, c.answer_Duration as f,
c.call_Type as g, c.ani_Area as h, c.undesktop_Notify_Missed_Call as i
FROM Call_Master as c, Device_Info do
WHERE c.answer_Duration=0 AND do.apply_State=2 and c.call_Type in (1,3)
AND do.device = c.callee_Device and (do.device in ('8760') )
AND c.start_Time_Yy=2008 and c.start_Time_Mm=2 and c.start_Time_Dd=18
order by c.start_Time desc)
union
(
select di.id as a,b.start_Time as b, b.ani as c, b.calling_Device as d, b.callee_Device as e, b.answer_Duration as f,
b.call_Type as g, b.ani_Area as h, b.undesktop_Notify_Missed_Call as i
FROM Call_detail as b, Device_Info di
WHERE b.answer_Duration=0 AND di.apply_State=2 and b.call_Type in (1,3)
AND di.device = c.callee_Device and (di.device in ('8760') )
AND b.start_Time_Yy=2008 and b.start_Time_Mm=2 and b.start_Time_Dd=18
order by b.start_Time desc
)
c.call_Type as g, c.ani_Area as h, c.undesktop_Notify_Missed_Call as i
FROM Call_Master as c, Device_Info do
WHERE c.answer_Duration=0 AND do.apply_State=2 and c.call_Type in (1,3)
AND do.device = c.callee_Device and (do.device in ('8760') )
AND c.start_Time_Yy=2008 and c.start_Time_Mm=2 and c.start_Time_Dd=18
order by c.start_Time desc)
union
(
select di.id as a,b.start_Time as b, b.ani as c, b.calling_Device as d, b.callee_Device as e, b.answer_Duration as f,
b.call_Type as g, b.ani_Area as h, b.undesktop_Notify_Missed_Call as i
FROM Call_detail as b, Device_Info di
WHERE b.answer_Duration=0 AND di.apply_State=2 and b.call_Type in (1,3)
AND di.device = c.callee_Device and (di.device in ('8760') )
AND b.start_Time_Yy=2008 and b.start_Time_Mm=2 and b.start_Time_Dd=18
order by b.start_Time desc
)
wangjianming45 2008-03-25
UnionUnion All不但要求筛选列列一致，还有很重要一点（我们平时都没有太注意到的）就是字段的COLLATE也必须一致。你试着看看两个表字段的COLLATE是否一致？
PostgreSQL SELECT 语句 PostgreSQL SELECT 语句 PostgreSQL SELECT 语句用于从数据库中选取数据。 结果被存储在一个结果表中，称为结果集。 语法 SELECT 语句语法格式如下： SELECT column1, column2,...columnN FROM table_name; column1...
数据透视表SQL语句入门 整句语句的意思就是，将两个查询结果作为新的查询表分别命名为Hz1、Hz2，用 ”where hz1.分公司=Hz2.分公司“来组合数据， 没有条件的制约的话，将统计的结果再进行除数运算， 各品种的分组统计数（分组含品种字段）...
MySQL中select语句使用order按行排序 再来回顾一下SQL语句中的select语句的语法： Select 语句的基本语法： Select <列的集合> from <表名> where <条件> order by <排序字段和方式> 如果要对查询结果按某个字段排序，则要使用order by 子句...
经典全面的SQL语句大全 全外连接：不仅包括符号连接表的匹配行，还包括两个连接表中的所有记录。 其次，大家来看一些不错的sql语句 1、说明：复制表(只复制结构,源表名：a 新表名：b) (Access可用) 法一：select * into b from a ...
SQL查询语句精华 交叉连接不带WHERE 子句，它返回被连接的两个表所有数据行的笛卡尔积，返回到结果集合中的数据行数等于第一个表中符合查询条件的数据行数乘以第二个表中符合查询条件的数据行数。 例，titles表中有6类图书，而...
数据库多表查询及嵌套查询子查询语句示例 简单数据库但表查询 select * from kjbdsjk where 姓名 = 王勇 and 分数 = 87...7.在UPDATE语句中应用子查询:update kjbdsjk set 工资 = 工资+1000 where 工资 in (select 工资 from kjbdsjk where 工资 > "+stredit+")
数据库操作语句大全(sql) 全外连接：不仅包括符号连接表的匹配行，还包括两个连接表中的所有记录。 12、分组:Group by: 一张表，一旦分组 完成后，查询后只能得到组相关的信息。 组相关的信息：（统计信息） count,sum,max,min,avg 分组的...
用VBS通过SQL语句查找多个文本内重复的QQ号 使用VBS，通过ODBC SQL的select语句，查找多个文本内重复的QQ号； 使用VBS，通过一般循环遍历的方式，查找多个文本内重复的QQ号。 该资源展示了一种巧妙的方法：将文本当做数据库的表，使用VBS数据库表执行SQL语句。...
SQL练习4-SELECT（连接查询、嵌套查询） 连接查询的WHERE子句中来连接两个表的条件称为连接条件或连接谓词，其一般格式： [.][.] 其中比较运算符主要为=、>、=、<=、!=（或者是）等。 此外连接谓词还可以使用以下形式： [.] BETWEEN [.] AND [.] 当连接...
数据库按照指定多个字段去重复查询sql语句 SELECT m.* FROM dbo.Sheet1$ m,( SELECT ZCMC,ZCFL,XH FROM dbo.Sheet1$ GROUP BY ZCMC,ZCFL,XH HAVING COUNT(1)>1 ) AS m1 WHERE m.ZCMC=m1.ZCMC AND m.ZCFL=m1.ZCFL and m.XH=m1.XH
SQL练习4 – SELECT（连接查询、嵌套查询） 连接查询：同时涉及两个以上的表的查询 [.] [.] 连接字段：连接条件中的列名称 如：Sno为上面例子中的连接字段 注意：连接字段类型必须是可比的，但名字不必相同 1.等值与非等值连接查询 （等值连接：连接运算符为= ...
经典SQL语句大全 全外连接：不仅包括符号连接表的匹配行，还包括两个连接表中的所有记录。 12、分组:Group by: 一张表，一旦分组 完成后，查询后只能得到组相关的信息。 组相关的信息：（统计信息） count,sum,max,min,avg 分组的...
同一个sql语句 连接两个数据库服务器 exec sp_addlinkedserver ‘逻辑名称’,”,’SQLOLEDB’,’远程服务器名或ip地址’ exec sp_...表名称 这是一个完整的sql语句 使用完成之后要，删除掉建立的虚拟连接 exec sp_dropserver ‘逻辑名称’,’droplogins’
