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 |
|
philip_95
Starting Member
1 Post |
 Posted - 2014-08-22 : 17:43:10
|
| how can run a query that would not list duplicate e.g.item 1 section 1item 2 section 1item 3 section 1item 4 section 1item 5 section 2item 6 section 2item 7 section 3the output would besection 1section 2section 3 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-08-22 : 17:52:33
|
| select distinct yoursectioncolumnnamefrom yourtableTara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
|
|
|
List items once