潘哥给的牛叉的sql语句哈

SELECT a.contractname 项目名称, COUNT(b.ID) 文档数量,COUNT(c.maintitle)
FROM EDM_CONTRACTINFO a INNER JOIN EDM_FILEINFO b
ON  a.PROJECTID=b.PROJECTID
LEFT  JOIN EDM_E_GCJGZL c
ON b.O_PROJECTNO = c.O_PROJECTNO 
GROUP BY a.contractname

 

 

SELECT DISTINCT(d.applydocumentname),xz.下载次数,ll.浏览次数 FROM
documentapply d
LEFT JOIN
(SELECT applydocumentname , COUNT(applycontent) 下载次数
FROM documentapply  WHERE applycontent='2' AND buildermanageropinion = '1' GROUP BY applydocumentname) xz
ON d.applydocumentname = xz.applydocumentname
LEFT JOIN
(SELECT applydocumentname , COUNT(applycontent) 浏览次数
FROM documentapply  WHERE applycontent='1' AND buildermanageropinion = '1' GROUP BY applydocumentname) ll
ON d.applydocumentname = ll.applydocumentname
WHERE d.buildermanageropinion='1'  AND d.APPLYCONTENT IS NOT NULL AND d.applydocumentname IS NOT NULL
AND d.APPLYCONTENT IN ('1','2')



Select a.applyname 申请人, a.applyunit 所在单位, a.tel 联系电话, a.applydocumentname 文档名称,
a.documentgoal 利用目的, a.applydate 日期,
(Case When a.applycontent='1' Then '浏览' When a.applycontent='2' Then '下载' End) 利用类型 From documentapply a