急！！！请各位大神帮忙看看。

2013-01-28 11:43:00 183 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

Python实战：用NumPy实现LU分解与QR分解（附代码对比）本文深入探讨了使用NumPy实现LU分解与QR分解的实战方法，通过代码对比分析了两种矩阵分解技术的原理、数值稳定性差异及核心应用场景。LU分解适用于高效求解线性方程组，而QR分解凭借其正交化特性，在求解最小二乘问题和处理病态矩阵时更具优势。文章提供了详细的Python代码示例，帮助开发者根据具体问题选择最合适的分解方法。阅读详情

select accountName,accountId,
(select count(logId) from syslog where objectTypeId=2010 and eventTypeId=2 and syslog.accountId=sysaccount.accountId and syslog.createTime between '2012-12-28 00:00:00' and '2013-01-28 23:59:59')as addresource,
(select count(logId) from syslog where objectTypeId=2010 and eventTypeId=4 and syslog.accountId=sysaccount.accountId and syslog.createTime between '2012-12-28 00:00:00' and '2013-01-28 23:59:59')as updateresource,
(select count(logId) from syslog where objectTypeId=2010 and eventTypeId=3 and syslog.accountId=sysaccount.accountId and syslog.createTime between '2012-12-28 00:00:00' and '2013-01-28 23:59:59')as deleteresource,
(select count(logId) from syslog where objectTypeId=2015 and eventTypeId=4 and syslog.accountId=sysaccount.accountId and syslog.createTime between '2012-12-28 00:00:00' and '2013-01-28 23:59:59')as updatejianli,
(select count(logId) from syslog where objectTypeId=2010 and eventTypeId=5 and syslog.accountId=sysaccount.accountId and syslog.createTime between '2012-12-28 00:00:00' and '2013-01-28 23:59:59')as lookresource,
(select count(logId) from syslog where objectTypeId=2010 and eventTypeId=6 and syslog.accountId=sysaccount.accountId and syslog.createTime between '2012-12-28 00:00:00' and '2013-01-28 23:59:59')as shangchuanresourcefujian,
(select count(logId) from syslog where objectTypeId=2010 and eventTypeId=7 and syslog.accountId=sysaccount.accountId and syslog.createTime between '2012-12-28 00:00:00' and '2013-01-28 23:59:59')as xiazairesourcefujian,
(select count(logId) from syslog where objectTypeId=2010 and eventTypeId=8 and syslog.accountId=sysaccount.accountId and syslog.createTime between '2012-12-28 00:00:00' and '2013-01-28 23:59:59')as shuanchuresourcefujian,
(select count(logId) from syslog where objectTypeId=2030 and eventTypeId=2 and syslog.accountId=sysaccount.accountId and syslog.createTime between '2012-12-28 00:00:00' and '2013-01-28 23:59:59')as addresourcepingyu,
(select count(logId) from syslog where objectTypeId=2040 and eventTypeId=4 and syslog.accountId=sysaccount.accountId and syslog.createTime between '2012-12-28 00:00:00' and '2013-01-28 23:59:59')as udpateresourcebeijingdiaocha,
(select count(logId) from syslog where objectTypeId=2050 and eventTypeId=4 and syslog.accountId=sysaccount.accountId and syslog.createTime between '2012-12-28 00:00:00' and '2013-01-28 23:59:59')as lookresourcemingganxinxi,
(select count(logId) from syslog where objectTypeId=2050 and eventTypeId=5 and syslog.accountId=sysaccount.accountId and syslog.createTime between '2012-12-28 00:00:00' and '2013-01-28 23:59:59')as shenpiresourcemingganxinxi,
(select count(logId) from syslog where objectTypeId=2080 and eventTypeId=2 and syslog.accountId=sysaccount.accountId and syslog.createTime between '2012-12-28 00:00:00' and '2013-01-28 23:59:59')as addresourcexunfang,
(select count(logId) from syslog where objectTypeId=2080 and eventTypeId=4 and syslog.accountId=sysaccount.accountId and syslog.createTime between '2012-12-28 00:00:00' and '2013-01-28 23:59:59')as updateresourcexunfang,
(select count(logId) from syslog where objectTypeId=2080 and eventTypeId=3 and syslog.accountId=sysaccount.accountId and syslog.createTime between '2012-12-28 00:00:00' and '2013-01-28 23:59:59')as shanchuresourcexunfang,
(select count(logId) from syslog where objectTypeId=2090 and eventTypeId=2 and syslog.accountId=sysaccount.accountId and syslog.createTime between '2012-12-28 00:00:00' and '2013-01-28 23:59:59')as addresourcexunfangpingyu,
(select COUNT(Distinct resCommentsId) from rescomments rt where (select createAccId from resource where resourceId=rt.resourceId)!= rt.commentAccId and rt.createTime between '2012-12-28 00:00:00' and '2013-01-28 23:59:59' and rt.commentAccId=sysaccount.accountId)as addxunfangpingyufeibenren,
(select count(logId) from syslog where objectTypeId=20100 and eventTypeId=2 and syslog.accountId=sysaccount.accountId and syslog.createTime between '2012-12-28 00:00:00' and '2013-01-28 23:59:59')as addmubiaogongsi,
(select count(logId) from syslog where objectTypeId=20100 and eventTypeId=4 and syslog.accountId=sysaccount.accountId and syslog.createTime between '2012-12-28 00:00:00' and '2013-01-28 23:59:59')as updatemubiaogongsi,
(select count(logId) from syslog where objectTypeId=20100 and eventTypeId=3 and syslog.accountId=sysaccount.accountId and syslog.createTime between '2012-12-28 00:00:00' and '2013-01-28 23:59:59')as shanchumubiaogongsi,
(select count(logId) from syslog where objectTypeId=20110 and eventTypeId=2 and syslog.accountId=sysaccount.accountId and syslog.createTime between '2012-12-28 00:00:00' and '2013-01-28 23:59:59')as shangchuanmobiaogongsifujian,
(select count(logId) from syslog where objectTypeId=20110 and eventTypeId=6 and syslog.accountId=sysaccount.accountId and syslog.createTime between '2012-12-28 00:00:00' and '2013-01-28 23:59:59')as xiazaimubiaogongsifujian,
(select count(logId) from syslog where objectTypeId=20100 and eventTypeId=7 and syslog.accountId=sysaccount.accountId and syslog.createTime between '2012-12-28 00:00:00' and '2013-01-28 23:59:59')as shanchumobiaogongsifujian,
(select count(logId) from syslog where objectTypeId=820100 and eventTypeId=2 and syslog.accountId=sysaccount.accountId and syslog.createTime between '2012-12-28 00:00:00' and '2013-01-28 23:59:59')as zhuanhuaxianren,
(select count(logId) from syslog where objectTypeId=820100 and eventTypeId=4 and syslog.accountId=sysaccount.accountId and syslog.createTime between '2012-12-28 00:00:00' and '2013-01-28 23:59:59')as upatexianren,
(select count(logId) from syslog where objectTypeId=820100 and eventTypeId=3 and syslog.accountId=sysaccount.accountId and syslog.createTime between '2012-12-28 00:00:00' and '2013-01-28 23:59:59')as shanchuxianren,
(select count(logId) from syslog where objectTypeId=820110 and eventTypeId=2 and syslog.accountId=sysaccount.accountId and syslog.createTime between '2012-12-28 00:00:00' and '2013-01-28 23:59:59')as shenqingzhuanhuaxianren,
(select count(logId) from syslog where objectTypeId=820110 and eventTypeId=4 and syslog.accountId=sysaccount.accountId and syslog.createTime between '2012-12-28 00:00:00' and '2013-01-28 23:59:59')as pizhunzhuanhuaxianren,
(select count(logId) from syslog where objectTypeId=820110 and eventTypeId=3 and syslog.accountId=sysaccount.accountId and syslog.createTime between '2012-12-28 00:00:00' and '2013-01-28 23:59:59')as jujuezhuanhuaxianrenshenqin
from dbo.sysaccount where status not in(2,3) order by accountName asc

请各位大神帮忙看看这个查询有什么问题？查询半天都不出结果。急求！！！

...全文