Count function

[Niksen]

I need to make a SQL String that counts the number of users in certain units. Ex:

I need to know how many users there is in the different departments.

Ex:
Region, Country, City, Department Number of users
Asia China Beijing HR Department xxx

Region, Country, City, Department is different tables in the database, but related to each other (Asia -> China -> Beijing...)

Please help

 

[r937]

if you could show the query to retrieve a particular user along with the other fields, i.e. the query to produce this --

Region Country City, Department Username
Asia China Beijing HR Department Todd

then we can show you how to make a very small change to count the number of users


r937.com | rudy.ca

 

[SQLSister]

Group by and count(*) are what you need here. For more specificity, then follow rudy's advice above.

"NOTHING is more important in a database than integrity." ESquared