计算行项目类别 [英] Count Line Item Catagories

问题描述

我正在尝试使用sql查询来计算按类别显示在网页上的项目数。任何帮助将不胜感激



i想要计算Catagories的工作数



喜欢

I'm trying to get a sql query working to count the number of items by their categories to display on a webpage. Any assistance would be appreciated

i want to count the Catagories with jobs

like

Sales&Marketing(5)
Accounts and Finance(2)

如此...我的桌子是

CataGories 表

as so on.. my tables are
CataGories Table

CatID   CatName
1       Sales&Markting
2       Account and Finance
3       Web DEVELOPMENT
4       Media

和其他表格< b>工作

and other table as Job

JobID  CatID  JOBtitle
  1 2 Sales Manager
  2       2    Seles Executive
  2       3    Java Developer

所以请告诉我我理解得到的结果

So plz tell me i m understand to get result

推荐答案

试试：

Try:

SELECT c.CatName, COUNT(j.JobID) FROM Job j 
JOIN Catagories c ON j.CatID=c.CatID 
GROUP BY C.CatName

尝试使用以下查询：

Try to use below query:

SELECT 
FROM (CatName + ' (' + CONVERT(VARCHAR(30),CountOfCtgs) + ')'
    SELECT C.CatName, COUNT(C.CatName) AS CountOfCtgs
    FROM Categories AS C INNER JOIN Job AS J ON C.CatID = J.CatID
    GROUP BY C.CatName
    ORDER BY C.CatName
) AS T

我几乎没有尝试并解决它的问题

感谢所有

i hardly trying and solove its problem
thanks to all

Quote：

SELECT c.CatName，COUNT（j.JobID）as Result FROM Job j

right JOIN CATAGORIES c ON j .CatID = c.CatID

GROUP BY C.CatName

SELECT c.CatName, COUNT(j.JobID) as Result FROM Job j
right JOIN CATAGORIES c ON j.CatID=c.CatID
GROUP BY C.CatName

这篇关于计算行项目类别的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！