Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-04-22 : 12:38:25
|
Marty writes "Got a question,
To get to the point, I am working for my University and they want a report of how many "Doctorates" they have in each "College", Colleges like College of Business, Education, etc. The data has been setup where I have a list of Degrees in one table, but a list of Colleges in another. I want to break it down by College. Basically Count the number of Doctorates for Business...
So I want it to read...
Business 25
Education 30
Is there any way to just select a field name from T1 and then Count the number of records in T2?" |
|
|
|
|
|
SQL Count