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 |
|
jept
Starting Member
14 Posts |
 Posted - 2007-04-24 : 17:59:57
|
| I have a table called emails with a field named emailaddress and some emailaddress are entered more than once. I want to be able to list all emailaddress just once. is there an sql statement that I could use to generate this. |
|
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
Posted - 2007-04-24 : 18:15:21
|
| Look in Books Online for DISTINCT and GROUP BY. That should get you going.-Ryan |
 |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2007-04-24 : 21:29:36
|
| One question ?Why is the info in that table not unique ??? |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-04-25 : 01:04:51
|
| Maybe because two spouses can use same email-address?Peter LarssonHelsingborg, Sweden |
|
|
|
|
|
|
not having duplicate data