Click here to Skip to main content
15,030,228 members
Please Sign up or sign in to vote.
3.00/5 (1 vote)
See more:
Hi all

i have one join query that displays collegeid,collegename, assignid

i want to get the count of collegeid. how to write count query in below query.
please help


SELECT CollegeMaster.CollegeId, CollegeMaster.CollegeName, AssignMaster.TitleId AS Expr3, AssignMaster.AssignId, DomainMaster.DomainName, StudentMaster.CollegeId AS Expr1, TitleMaster.*
FROM AssignMaster INNER JOIN StudentMaster ON AssignMaster.ContactNo =
StudentMaster.ContactNo INNER JOIN
CollegeMaster ON StudentMaster.CollegeId = CollegeMaster.CollegeId INNER JOIN
TitleMaster ON AssignMaster.TitleId = TitleMaster.TitleId INNER JOIN
DomainMaster ON TitleMaster.DomainId = DomainMaster.DomainId AND TitleMaster.DomainId = DomainMaster.DomainId where CollegeMaster.CollegeId='8' and TitleMaster.TitleId='1
Posted

1 solution

SQL
SELECT COUNT(CollegeMaster.CollegeId),CollegeMaster.CollegeId, CollegeMaster.CollegeName, AssignMaster.TitleId AS Expr3, AssignMaster.AssignId, DomainMaster.DomainName, StudentMaster.CollegeId AS Expr1,
FROM AssignMaster
INNER JOIN StudentMaster
ON AssignMaster.ContactNo = StudentMaster.ContactNo
INNER JOIN CollegeMaster
ON StudentMaster.CollegeId = CollegeMaster.CollegeId
INNER JOIN TitleMaster
ON AssignMaster.TitleId = TitleMaster.TitleId
INNER JOIN DomainMaster
ON TitleMaster.DomainId = DomainMaster.DomainId
AND TitleMaster.DomainId = DomainMaster.DomainId
where CollegeMaster.CollegeId='8'
and TitleMaster.TitleId='1'
group by CollegeMaster.CollegeName, AssignMaster.TitleId,AssignMaster.AssignId, DomainMaster.DomainName, StudentMaster.CollegeId 
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900