Click here to Skip to main content
11,701,948 members (64,329 online)
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 Maciej Los 420
1 Sergey Alexandrovich Kryukov 355
2 OriginalGriff 314
3 Mika Wendelius 119
4 CHill60 105
0 OriginalGriff 8,344
1 Sergey Alexandrovich Kryukov 7,507
2 CPallini 4,922
3 Maciej Los 4,371
4 Mika Wendelius 3,556


Advertise | Privacy | Mobile
Web02 | 2.8.150819.1 | Last Updated 5 Nov 2012
Copyright © CodeProject, 1999-2015
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