---
Declare @SID1 int
Declare @SID2 int
--@SID1=38
select top 1 @SID1=SID from (select top 60 SID from Equipment group by SID order by SID ) A order by SID desc
--Count(SenInID)=133
select count(SenInID) from Equipment where SID<=@SID1 --用下列语句查询错误??
select count(*) from Equipment where
SID<=(select top (1) SID from
(select top (30) SID from Equipment group by SID order by SID) as a order by SID desc)如何将SQL语句合并成一条SQL语句?
解决方案 »
- udl无法连接本机数据库
- 你觉得Northwind数据库中建立这么多表,而且表与表之间有着复杂的关系,这是为什么?
- 问一select写法问题
- 请问SQL SERVER2000中订阅与发布的具体操作?
- 怎样得到存储过程的执行行数??
- 如何在企业管理器里面往表里添加文件作为字段内容?
- 求一条救命的SQL语句~~~
- 这个触发器怎么写?
- 我是一个新手,请大家给我一些关于SQL的启蒙教育(最好有例子),多谢了.
- 系统定义如何完全删除掉,邹老大们来看看啊,SYSOBJECTS!!!!!!!
- 使用powerdesigner15.0逆向功能,从远程服务器的sql server2000无法得到对应的PDM?
- 求教 这个sql如何写哇。。。。
select count(*) from Equipment where
SID<=(select top (1) SID from
(select top (30) SID from Equipment group by SID order by SID) as a order by SID desc)查询语句错误???
SID<=
(select top 1 SID from
(select top 30 SID from Equipment group by SID order by SID) as a
order by SID desc)
select count(*) from Equipment where
SID<=(select top (1) SID from
(select top (30) SID from Equipment group by SID order by SID) as a order by SID desc)服务器: 消息 170,级别 15,状态 1,行 2
第 2 行: '(' 附近有语法错误。
服务器: 消息 170,级别 15,状态 1,行 3
第 3 行: '(' 附近有语法错误。
top (1)改为 top 1 top (30)改为 top 30 或者用前面写给你的句子都行,一样的
换成这样
select count(*) from Equipment where
SID<=(select top 1 SID from
(select top 30 SID from Equipment group by SID order by SID) as a order by SID desc)