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 - 2004-01-26 : 07:22:15
|
| Victor writes "How can I select a certain data from a table, and showing the table with no duplicates? If I just do a simple select statement on a specific column in a table, I would have duplicates of the same data. However, I'm trying to list that column without having the duplicates." |
|
|
raymondpeacock
Constraint Violating Yak Guru
367 Posts |
Posted - 2004-01-26 : 07:28:09
|
| Use the DISTINCT clause. See BOL for more details.Raymond |
 |
|
|
|
|
|
Selecting data, and showing no duplicates