SELECT a.userid,manageid, username, aname,tel,addtype,a.biaoshi as biaoshi,firstchange,lastchange,
lastyuer,shou,zhao,jiao,yuer, huobi,beizhu,sure,suredate,a.ctrl as ctrl from users left join manage a
on users.userid=a.userid where firstchange in (select top 1 firstchange from manage where userid =
a.userid and a.huobi = huobi and live='normal'and power=3 order by firstchange desc) order by cast(a.biaoshi as int),
username,a.huobi asc
主要是慢在where firstchange in这里. 大家有什么建议帮忙优化一下
解决方案 »
- 冰天雪地跪地求教
- 如何将ACCESS里面的数据转到SQL SERVER 2005中。
- 在视图中能否创建存储过程并执行!是否可有示例,谢谢
- 为什么sql服务器的密码不支持大小写?
- DTSRun如何将progress内的数据导入到mssql
- 求解
- XP PRO 下安装 SQL 2005企业版+VS2008 TS版本
- 如何在MS_SQL中实现针对一个数据库的所有表进行全程搜索???
- 一个我没有解决了的问题,请高手指点一下!
- 急急!!!在存储过程中怎样跳过被锁定的表?
- SET IDENTITY_INSERT 表名 ON 不能用,怎么回事?
- SQL Server 2005 同步数据到 SQL Server 2000 问题?
SELECT a.userid,manageid, username, aname,tel,addtype,a.biaoshi as biaoshi,firstchange,lastchange,
lastyuer,shou,zhao,jiao,yuer, huobi,beizhu,sure,suredate,a.ctrl as ctrl
from users left join (Select a.*
From manage a Right Join (Select userid,huobi,Max(firstchange) As firstchange From manage
Where live='normal'and power=3 Group By userid,huobi) T
On (userid = a.userid and a.huobi = huobi ))
order by cast(a.biaoshi as int),username,a.huobi asc