Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: SQL-Server
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 5-Nov-12 1:05am

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

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 
  Permalink  

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

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 499
1 OriginalGriff 393
2 Maciej Los 385
3 CPallini 189
4 CHill60 180
0 OriginalGriff 6,152
1 Sergey Alexandrovich Kryukov 5,312
2 Maciej Los 3,279
3 Peter Leow 3,184
4 DamithSL 2,490


Advertise | Privacy | Mobile
Web03 | 2.8.140721.1 | Last Updated 5 Nov 2012
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100