|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#1
November 2nd, 2004, 04:44 PM
|
|||
|
|||
|
SQL Query - HELP
I have a table called evolution project with four fields: month, proj_id (Project ID), user_id (User ID) and role.
The month field is in the format: 200202. All the other fields are numbers. Each project has multiple users. A user may be associated with more than one project. The role field is simply a number based on a key for different roles the user can performin the project: developer, passive etc. The number of users associated with a project is called the degree of the project. I want to query out all projects with a degree greater than a certain constant 'c', using SQL. HELP PLEASE.
|
|
#2
November 4th, 2004, 10:42 AM
|
|||
|
|||
|
Here is a basic sample
Code:
Select Q1.Proj_ID From (SELECT Table4.Proj_ID, Count(Table4.User_ID) AS CountUsers FROM Table4 GROUP BY Table4.Proj_ID) as Q1 where Q1.CountUsers > 4; S-
|
|
| Viewing: ASP Free Forums > Database > SQL Development > SQL Query - HELP |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
