--来访人员SELECT COUNT(*) FROM(SELECT * FROM T_CHREC t2 INNER JOIN (select t.device_no from
VISIT_MANAGE t WHERE substr(t.belong_area_code,0,18) = '440604530011050001') t3
ON t2.nohotel = t3.device_no)
--来访车辆SELECT COUNT(t2.id) FROM T_CAPTURE t2 INNER JOIN (
SELECT t.device_no FROM capture_manage t WHERE substr(t.belong_area_code,0,18) = '440604530011050001')
t3 ON t2.device_mac = t3.device_no
怎么让两个结果组成一个临时表 如
表Temp
来访人员 来访车辆
2 2
求教!!!
VISIT_MANAGE t WHERE substr(t.belong_area_code,0,18) = '440604530011050001') t3
ON t2.nohotel = t3.device_no)
--来访车辆SELECT COUNT(t2.id) FROM T_CAPTURE t2 INNER JOIN (
SELECT t.device_no FROM capture_manage t WHERE substr(t.belong_area_code,0,18) = '440604530011050001')
t3 ON t2.device_mac = t3.device_no
怎么让两个结果组成一个临时表 如
表Temp
来访人员 来访车辆
2 2
求教!!!
解决方案 »
- 如何提高数据库的运行速度? 如果我的SQL的数据表有很多记录并且某个字段保存大的BLOB(如视频文件)这样数据很大,甚至达到几个G,
- 数据库加密,怎么弄?希望大家出发发言讨论
- xp_cmdshell打开了,听说不安全了,怎样关闭啊?小弟先感谢了!
- 求一SQL语句,一时想不出好的办法
- 这是计算一个月第一天的SQL 脚本: SELECT DATEADD(mm, DATEDIFF(mm,0,getdate()), 0)
- SQL server安装警告,SQL Server 版本的操作系统兼容性 (警告)
- sql 分组查询中每组中某列的各行字符数据相加显示
- 备份日志后,还原数据库
- 紧急求救,jdbc连不上sqlser2000
- vb2010连接sql server2008出错,折腾好久啦!!!
- 如何知道那些查询语句让服务器变慢?
- 【求助】北大出的一个数据库题
VISIT_MANAGE t WHERE substr(t.belong_area_code,0,18) = '440604530011050001') t3
ON t2.nohotel = t3.device_no)),来访车辆 = (SELECT COUNT(t2.id) FROM T_CAPTURE t2 INNER JOIN (
SELECT t.device_no FROM capture_manage t WHERE substr(t.belong_area_code,0,18) = '440604530011050001')
t3 ON t2.device_mac = t3.device_no)这样
SELECT COUNT(*) FROM(SELECT * FROM T_CHREC t2 INNER JOIN (select t.device_no from
VISIT_MANAGE t WHERE substr(t.belong_area_code,0,18) = '440604530011050001') t3
ON t2.nohotel = t3.device_no),
SELECT COUNT(t2.id) FROM T_CAPTURE t2 INNER JOIN (
SELECT t.device_no FROM capture_manage t WHERE substr(t.belong_area_code,0,18) = '440604530011050001')
t3 ON t2.device_mac = t3.device_no
) into #temp
参考:
select
(SELECT COUNT(*) FROM(
SELECT *
FROM T_CHREC t2 INNER JOIN (
select t.device_no from VISIT_MANAGE t WHERE substring(t.belong_area_code,0,18) = '440604530011050001'
)t3 ON t2.nohotel = t3.device_no
)
)来访人员,
(SELECT COUNT(t2.id)
FROM T_CAPTURE t2 INNER JOIN (
SELECT t.device_no FROM capture_manage t WHERE substring(t.belong_area_code,0,18) = '440604530011050001'
)t3 ON t2.device_mac = t3.device_no
)来访车辆
SELECT COUNT(*) FROM(
SELECT *
FROM T_CHREC t2 INNER JOIN (
select t.device_no from VISIT_MANAGE t WHERE substring(t.belong_area_code,0,18) = '440604530011050001'
)t3 ON t2.nohotel = t3.device_no
)tb
)来访人员,
(SELECT COUNT(t2.id)
FROM T_CAPTURE t2 INNER JOIN (
SELECT t.device_no FROM capture_manage t WHERE substring(t.belong_area_code,0,18) = '440604530011050001'
)t3 ON t2.device_mac = t3.device_no
)来访车辆
select * from
(
SELECT COUNT(*) as 来访人员
FROM
T_CHREC t2
INNER JOIN
VISIT_MANAGE t3
ON t2.nohotel = t3.device_no
and left(t3.belong_area_code,18) = '440604530011050001'
) a,(
SELECT COUNT(t2.id) as 来访车辆
FROM T_CAPTURE t2
INNER JOIN
capture_manage t3
ON t2.device_mac = t3.device_no
and left(t3.belong_area_code,18) = '440604530011050001'
) b