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 |
|
arusu
Yak Posting Veteran
60 Posts |
 Posted - 2010-08-26 : 16:36:52
|
| i have a view that will displaycategory name address1 andrew 122 greg 211 greg 211 null nullso i have a website that should display all of the categories from this view but i only want it to show each category once. I can't select distinct because i need to access the other information in the view like the name and address and if i select distinct, greg will only show up once.... i just need distinct on category |
|
|
|
|
|
select unique from view