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 |
|
maya_zakry
Constraint Violating Yak Guru
379 Posts |
 Posted - 2007-01-16 : 22:59:37
|
| hello,how to SELECT col1 that has only multiple entry?col1 wwwwxxzzwill return wwwthanks~~~Focus on problem, not solution~~~ |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-01-16 : 23:06:30
|
| I suspect this is a homework assignment, but I'll throw you a bone...SELECT col1FROM Table1GROUP BY col1HAVING COUNT(*) > 1Tara Kizer |
 |
|
|
maya_zakry
Constraint Violating Yak Guru
379 Posts |
Posted - 2007-01-18 : 20:53:04
|
| no it's not homework :P, it's to check my db~~~Focus on problem, not solution~~~ |
|
|
|
|
|
|
Group By