下面是我的一个分页查询语句,
当下面红色部分的条件加上后就会超时失败, 这是什么原因啊
where
S_ID = 1 and
AlarmRecords_tbl.AR_ID
not in
select top 10 * from AlarmRecords_tbl
left join car_tbl on car_tbl.C_ID= AlarmRecords_tbl.C_ID
left join UserToCarUserInfo_tbl on UserToCarUserInfo_tbl.UserID= car_tbl.UserID
left join CarUserInofo on CarUserInofo.UserInfoID= UserToCarUserInfo_tbl.UserInfoID
left join CarofShop_tbl on CarofShop_tbl.C_ID= AlarmRecords_tbl.C_ID
where
S_ID = 1 and
AlarmRecords_tbl.AR_ID
not in (
select top (( 2 - 1)* 10) AR_ID from AlarmRecords_tbl
left join car_tbl on car_tbl.C_ID= AlarmRecords_tbl.C_ID
left join UserToCarUserInfo_tbl on UserToCarUserInfo_tbl.UserID= car_tbl.UserID
left join CarUserInofo on CarUserInofo.UserInfoID= UserToCarUserInfo_tbl.UserInfoID
left join CarofShop_tbl on CarofShop_tbl.C_ID= AlarmRecords_tbl.C_ID
where S_ID = 1
order by AlarmRecords_tbl.AR_ID desc )
order by AlarmRecords_tbl.AR_ID desc
解决方案 »
- 如何将多个ACCESS表一次行导入SQL中已建好的库
- 引用公式
- 关于视图更新的问题,数据是从两表查出的,一个表存是一个月内记录,一个表存的是一个月前的记录。
- 求一个老软件,sql server 6.5或6.0
- query.exec("set names utf8") 这是啥意思
- 两个结构相同的表如何整合成一个表呢?
- 这个统计语句如何写???
- 请教如何让两台电脑上的SQL的数据库能同步更新!!!
- 如何体现SQL SERVER 作为后台的优越性?
- nvarchar的长度问题,急......
- 如何将数据库中查询到的数据再加上一行自定义数据
- win7安装SQL Server2008最后提示reporting service失败?
select top 10 * from AlarmRecords_tbl
left join car_tbl on car_tbl.C_ID= AlarmRecords_tbl.C_ID
left join UserToCarUserInfo_tbl on UserToCarUserInfo_tbl.UserID= car_tbl.UserID
left join CarUserInofo on CarUserInofo.UserInfoID= UserToCarUserInfo_tbl.UserInfoID
left join CarofShop_tbl on CarofShop_tbl.C_ID= AlarmRecords_tbl.C_ID
where
AlarmRecords_tbl.AR_ID
not in (
select top (( 2 - 1)* 10) AR_ID from AlarmRecords_tbl
left join car_tbl on car_tbl.C_ID= AlarmRecords_tbl.C_ID
left join UserToCarUserInfo_tbl on UserToCarUserInfo_tbl.UserID= car_tbl.UserID
left join CarUserInofo on CarUserInofo.UserInfoID= UserToCarUserInfo_tbl.UserInfoID
left join CarofShop_tbl on CarofShop_tbl.C_ID= AlarmRecords_tbl.C_ID
where S_ID = 1
order by AlarmRecords_tbl.AR_ID desc)
order by AlarmRecords_tbl.AR_ID desc) t where S_ID=1
多次为 't' 指定了列 'C_ID'。
--> 这里不要用*,把需要返回的字段列出来..
--> 这里不要用*,把需要返回的字段列出来..
结果集不对 最后的结果集里 有 S_ID <>1 的记录