查找语法错误

[风之影子]

select top 10 MonitorID,dafcode,LeftPoleStress,BalanceStress,RightPoleStress,Displacement,MonitorTime,supportcode 
from [rtm_one] a inner join daf b on a.workfaceid=b.workfaceid 
where [monitorid]>
(
	select max([monitorid]) from 
	(
		select top -10 [monitorid] from [rtm_one] where select count(monitorid) from rtm_one where dafcode=0 and monitortime between '2006-11-01' and '2006-11-15'  order by		[monitorid] asc
	)as tblTmp
) 
and select count(monitorid) from rtm_one where dafcode=0 and monitortime between '2006-11-01' and '2006-11-15'  order by [monitorid] asc

错误提示如下：

消息 102，级别 15，状态 1，第 7 行
'-' 附近有语法错误。
消息 102，级别 15，状态 1，第 8 行
')' 附近有语法错误。

[华夏小卒]

top -10 这什么意思

[华夏小卒]

没有这个用法

[水族杰纶]

and select count(monitorid) from rtm_one where dafcode=0 and monitortime between '2006-11-01' and '2006-11-15' order by [monitorid] asc
??

[wsxcdx]

top -10

[水族杰纶]

select top -10
-->
select top 10 ....oder by col desc

[wzy_love_sly]

[无锡阔微信息科技]

直接top 10

[fwacky]

      select top -10 [monitorid] from [rtm_one] 
        where select count(monitorid) from rtm_one where dafcode=0 

--这是啥意思?????

[fwacky]

1，要给字段加上表的别名 列如： select top 10 a.MonitorID,b.dafcode.........
2,select top -10 [monitorid] from [rtm_one] 
        where select count(monitorid) from rtm_one where dafcode=0 
修改成 
select top 10 [monitorid] from [rtm_one] 
        where  dafcode=0 

[chaozi_249]

select top -10 [monitorid] from [rtm_one]
难不成Sql里面也有运算符重载

[microsofttyc]

top -10 没见过

[qiqi860819]

top -10 的问题吧