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 |
|
oahu9872
Posting Yak Master
112 Posts |
 Posted - 2006-03-29 : 07:55:03
|
| I want to see how many people have registered multiple times in a database we have here. Is there anyway I can do a count for any email address that is in the table more than once?Thanks |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-03-29 : 07:58:37
|
[code]select email, count(*)from yourtablegroup by emailhaving count(*) > 1[/code]
KHChoice is an illusion, created between those with power, and those without.Concordantly, while your first question may be the most pertinent, you may or may not realize it is also the most irrelevant |
 |
|
|
oahu9872
Posting Yak Master
112 Posts |
Posted - 2006-03-29 : 08:11:40
|
| great, thanks |
|
|
|
|
|
|
Count function.