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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-12-14 : 16:17:43
|
Darren writes "To Whom It May Concern:
I am attempting to create an SQL query that selects the userId, firstName, and email from table MEMBERS, returning only one significant email address.
The table is as follows:
userId,
firstName,
email
I want to return ANY userId, ANY firstName, and ANY email address. The problem I'm having is that there are duplicate email addresses in the DB. How can I select these items eliminating duplicate email addresses?
I appreciate any help! =)
Darren
<><" |
|
|
|
|
|
Select Statements that Pull Unique Values where Multiples May Exist