sybase数据库中索引导致sql语句执行不成功

最新推荐文章于 2019-07-17 14:12:48 发布

laizemu

最新推荐文章于 2019-07-17 14:12:48 发布

阅读量887

点赞数

分类专栏：数据库文章标签： sybase 数据库 sql null go

本文链接：https://blog.youkuaiyun.com/laizemu/article/details/4819473

版权

数据库专栏收录该内容

2 篇文章

订阅专栏

本文介绍了一种复杂的SQL查询案例，该查询旨在统计不同时间段内案件的状态，并详细展示了如何通过调整索引来优化查询性能。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

SELECT DISTINCT A.CASEPROP AS PROP,'旧存' AS AJLX,0 AS AJLXXH,A.CASE_PROP AS PROPNO
,M1=( SELECT COUNT(*) FROM CASES WHERE CASEPROP=A.CASEPROP AND
(PERMITDAY <'2008.12.26 00:00:00' AND (SHUTDAY IS NULL OR
SHUTDAY<'1900-01-01 00:00:00' OR SHUTDAY>='2008.12.26 00:00:00') )) ,
M2=( SELECT COUNT(*) FROM CASES WHERE CASEPROP=A.CASEPROP
AND (PERMITDAY <'2009.01.26 00:00:00' AND
(SHUTDAY IS NULL OR SHUTDAY<'1900-01-01 00:00:00' OR SHUTDAY>='2009.01.26 00:00:00') )) ,
M3=( SELECT COUNT(*) FROM CASES WHERE CASEPROP=A.CASEPROP
AND (PERMITDAY <'2009.02.26 00:00:00' AND (SHUTDAY IS NULL
OR SHUTDAY<'1900-01-01 00:00:00' OR SHUTDAY>='2009.02.26 00:00:00') )) ,
M4=( SELECT COUNT(*) FROM CASES WHERE CASEPROP=A.CASEPROP AND
(PERMITDAY <'2009.03.26 00:00:00' AND
(SHUTDAY IS NULL OR SHUTDAY<'1900-01-01 00:00:00' OR SHUTDAY>='2009.03.26 00:00:00') )) ,
M5=( SELECT COUNT(*) FROM CASES WHERE CASEPROP=A.CASEPROP AND
(PERMITDAY <'2009.04.26 00:00:00' AND
(SHUTDAY IS NULL OR SHUTDAY<'1900-01-01 00:00:00' OR SHUTDAY>='2009.04.26 00:00:00') )) ,
M6=( SELECT COUNT(*) FROM CASES WHERE CASEPROP=A.CASEPROP AND
(PERMITDAY <'2009.05.26 00:00:00' AND
(SHUTDAY IS NULL OR SHUTDAY<'1900-01-01 00:00:00' OR SHUTDAY>='2009.05.26 00:00:00') )) ,
M7=( SELECT COUNT(*) FROM CASES WHERE CASEPROP=A.CASEPROP AND
(PERMITDAY <'2009.06.26 00:00:00' AND (SHUTDAY IS NULL OR SHUTDAY<'1900-01-01 00:00:00' OR SHUTDAY>='2009.06.26 00:00:00') )) ,M8=( SELECT COUNT(*) FROM CASES WHERE CASEPROP=A.CASEPROP AND (PERMITDAY <'2009.07.26 00:00:00' AND (SHUTDAY IS NULL OR SHUTDAY<'1900-01-01 00:00:00' OR SHUTDAY>='2009.07.26 00:00:00') )) ,M9=( SELECT COUNT(*) FROM CASES WHERE CASEPROP=A.CASEPROP AND (PERMITDAY <'2009.08.26 00:00:00' AND (SHUTDAY IS NULL OR
SHUTDAY<'1900-01-01 00:00:00' OR SHUTDAY>='2009.08.26 00:00:00') )) ,M10=( SELECT COUNT(*) FROM CASES WHERE CASEPROP=A.CASEPROP AND (PERMITDAY <'2009.09.26 00:00:00' AND (SHUTDAY IS NULL OR SHUTDAY<'1900-01-01 00:00:00' OR SHUTDAY>='2009.09.26 00:00:00') )) ,M11=( SELECT COUNT(*) FROM CASES WHERE CASEPROP=A.CASEPROP AND (PERMITDAY <'2009.10.26 00:00:00' AND (SHUTDAY IS NULL OR SHUTDAY<'1900-01-01 00:00:00' OR SHUTDAY>='2009.10.26 00:00:00') )) FROM CASES A WHERE CASEPROP IS NOT NULL AND CASEPROP <> ''