sql优化-子查询索引
sql
select pi.*
, pp.project_type
, pp.project_name
, pp.project_stage
, pp.project_total_investment
, pp.project_state
,ifnull((
select
CASE
WHEN cast(pp.project_state as UNSIGNED INTEGER) <= 2 THEN
sum(if(ie.enroll_amount > ie...
原创
2021-04-09 17:57:46 ·
328 阅读 ·
0 评论