1.Log into CAD database with dsecs user
2.Select cout(*) as num, a.sjdbh from t_cjd a where TO_CHAR(a.cjkssj,’yyyy-mm’)=TO_Char(sysdate,’yyyy-mm’) gourp by a.sjdbh order by cout(*) desc
3. Select a.sldbh,a.jjkssj from t_sld a, t_cjd b where a.sjdbh=b.sjdbh and TO_CHAR(b.cjkssj,’yyyy-mm’)=TO_Char(sysdate,’yyyy-mm’) and TO_CHAR(a.jjkssj,’yyyy-mm’)<TO_Char(sysdate,’yyyy-mm’)
How to query call statistics on CAD database
Created: Feb 29, 2020 00:33:15
274
0
0
0
0
- x
- convention：
- Emotion(0)
Comment
Notice: To protect the legitimate rights and interests of you, the community, and third parties, do not release content that may bring legal risks to all parties, including but are not limited to the following:
- Politically sensitive content
- Content concerning pornography, gambling, and drug abuse
- Content that may disclose or infringe upon others ' commercial secrets, intellectual properties, including trade marks, copyrights, and patents, and personal privacy
