Counting Table Records. - SQL Server Forums

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.

All Forums

General SQL Server Forums

New to SQL Server Programming

Counting Table Records.

Author

Topic

Gerald30
Yak Posting Veteran

62 Posts

Posted - 2012-03-24 : 03:59:51

Hello.

Good after.

Any one can help me with this one.

Can you show me how to count this one.

Example I have 1 table

Field1 Field2 Field3
1 Rex admin
2 Philip admin
3 John User
4 Scoot Maintenance
5 Jhay User

How can i query it this way?

Field3 Record Count
Admin 2
User 2
Maintenance 1

Hope you could help me with this one thanks.

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2012-03-24 : 04:40:21

Hint : use GROUP BY

KH
[spoiler]Time is always against us[/spoiler]

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources