算导--7-2-b.构造新的PARTITION'(A, p, r)

本文介绍了一个改进的PARTITION算法——PARTITION',该算法能够将数组中的元素按大小分为三部分,并返回两个下标,使得小于、等于和大于基准值的元素分别位于不同区间。时间复杂度为O(r-p)。

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

修改PARTITION(A, p, r)来构造一个新的PARTITION'(A, p, r),他排列A[p..r]的元素,返回值是两个数组下标q和t,其中,p<=q<=t<=r,且有A[p..q-1]的中的元素都小于A[q],A[q..t]的元素都相等,A[t+1..r]的中的元素都大于A[q]。

时间复杂度是O(r-p)。

伪代码如下:


主要思想:若A[j]比A[p]小,则把目前标识与A[p]相等的值的最大下标加一处的值(第一个大于A[p]的值)放到原来A[j],目前标识与A[p]相等的值的最小下标的值(即第一个等于A[p]的值)放到目前标识与A[p]相等的值的最大下标加一处,然后把原来A[j]的值放到原来A[i]处,i和h一起向右移动;若A[j]和A[p]一样大,则目前标识与A[p]相等的值的最大下标加一处的值(第一个大于A[p]的值)与A[j]交换,h后移一位;若A[j]比A[p]大,把j后移一位。


select cau.realname, ( select count(1) from `wk_crm_activity` a left join wk_crm_customer c on a.activity_type_id = c.customer_id where if(a.activity_type = 2,c.status != 3,1=1) and a.create_user_id = v.create_user_id and DATE_FORMAT(a.create_time,'${sqlDateFormat}') between #{beginTime} and #{finalTime} and a.type = 1 ) as recordCount, count(v.customer_id) as customerCount from (SELECT a.activity_type_id as customer_id,a.create_user_id FROM wk_crm_activity a left join wk_crm_customer c on a.activity_type_id = c.customer_id WHERE c.status != 3 and a.activity_type = 2 AND a.type = 1 AND DATE_FORMAT(a.create_time, '${sqlDateFormat}') between #{beginTime} and #{finalTime} union SELECT a.customer_id,b.create_user_id FROM wk_crm_leads a LEFT JOIN wk_crm_activity b ON a.leads_id = b.activity_type_id AND activity_type = 1 AND type = 1 left join wk_crm_customer c on b.activity_type_id = c.customer_id WHERE c.status != 3 and DATE_FORMAT(b.create_time, '${sqlDateFormat}') between #{beginTime} and #{finalTime} union SELECT a.customer_id,b.create_user_id FROM wk_crm_contacts a LEFT JOIN wk_crm_activity b ON a.contacts_id = b.activity_type_id AND activity_type = 3 AND type = 1 left join wk_crm_customer c on b.activity_type_id = c.customer_id WHERE c.status != 3 and DATE_FORMAT(b.create_time, '${sqlDateFormat}') between #{beginTime} and #{finalTime} union SELECT a.customer_id,b.create_user_id FROM wk_crm_business a LEFT JOIN wk_crm_activity b ON a.business_id = b.activity_type_id AND activity_type = 5 AND type = 1 left join wk_crm_customer c on b.activity_type_id = c.customer_id WHERE c.status != 3 and DATE_FORMAT(b.create_time, '${sqlDateFormat}') between #{beginTime} and #{finalTime} ) as v left JOIN wk_admin_user cau on cau.user_id = v.create_user_id WHERE cau.user_id in <for collection="userIds" item="item"> #{item} </for> GROUP BY cau.user_id分析这个sql
最新发布
06-26
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值