这个意思?
select count(*) from my_view
where exists (select 1 from table1 where id = my_view.id)
select count(*) from my_view
where exists (select 1 from table1 where id = my_view.id)
解决方案 »
- 安装sqlserver2000时 提示:内部错误.请联与Microsoft技术支持联系. 是怎么回事,该如何解决?
- 关于top 50中50是数据库字段值的问题?
- 怎么创建视图
- SQL server2005配置管理器SQL server2005开启不能
- sp_addrolemember添加角色成员问题
- 在visual studio 2003 中实现c#与sql server的连接??
- 请高手指教:一Sql统计语句(统计分别按人和部门 统计文章总数目)
- 日志收缩问题
- 有关于sql server中小程序的一个问题!
- 关于查询更新是锁的问题
- 数据库还原 报错 超过限制大小
- 权限管理:用户可以创建数据表,并对自己创建的数据表有完全控制权,而对其它数据表只读。该如何做?
@sqls nvarchar(4000)
set @sqls='select @a=count(*) from V_test '
exec sp_executesql @sqls,N'@a int output',@num output
select @num
dbo.survey.localdesc, dbo.survey.terraindesc, dbo.survey.owner,
dbo.survey.version, dbo.survey.status, dbo.survey.submittime
FROM dbo.survey INNER JOIN
dbo.surveytable ON dbo.survey.id = dbo.surveytable.surveyid INNER JOIN
dbo.soil ON dbo.survey.id = dbo.soil.surveyid INNER JOIN
dbo.hole ON dbo.survey.id = dbo.hole.surveyid INNER JOIN
dbo.tower ON dbo.survey.towerid = dbo.tower.id
ORDER BY dbo.survey.submittime
我还想在输出中输出hole的满足条件dbo.survey.id = dbo.hole.surveyid的条数hole number,怎么输出?
SELECT TOP (100) PERCENT dbo.tower.serialNum, dbo.survey.name,
dbo.survey.localdesc, dbo.survey.terraindesc, dbo.survey.owner,
dbo.survey.version, dbo.survey.status, dbo.survey.submittime,
(select count(*) from dbo.hole where id = dbo.survey.id) as my_count
FROM dbo.survey INNER JOIN
dbo.surveytable ON dbo.survey.id = dbo.surveytable.surveyid INNER JOIN
dbo.soil ON dbo.survey.id = dbo.soil.surveyid INNER JOIN
dbo.hole ON dbo.survey.id = dbo.hole.surveyid INNER JOIN
dbo.tower ON dbo.survey.towerid = dbo.tower.id
ORDER BY dbo.survey.submittime
thks