110,536
社区成员
发帖
与我相关
我的任务
分享
SELECT SUM(OrderTable.HJSL) AS ex, Company.CompanyName
FROM OrderTable INNER JOIN
Company ON OrderTable.CompanyID = Company.CompanyID
WHERE (OrderTable.CompanyID > 1000)
GROUP BY Company.CompanyName
HAVING (SUM(OrderTable.HJJE) > 1000) and sum(company.companyid)>100
SELECT SUM(OrderTable.HJSL) AS ex, Company.CompanyName
FROM OrderTable INNER JOIN
Company ON OrderTable.CompanyID = Company.CompanyID
WHERE (OrderTable.CompanyID > 1000)
HAVING (SUM(OrderTable.HJJE) > 1000) and sum(company.companyid)>100
string pattern = @"(?is)\s*(SELECT\s+(?<select>.*?))?\s+(FROM\s+(?<from>.*?))?\s+(WHERE\s+(?<where>.*?))?\s+(GROUP\s+by\s+(?<groupby>.*?))?\s+(Having\s+(?<having>.*?))?\s+$";