Devendra  Kumar

Devendra Kumar

  • NA
  • 517
  • 245.3k

select distinct value with all column

Apr 9 2016 7:55 AM
please solve this query  i want show all fields from  tbl_Image_Master but tagname show but not repeat 
i.e distinct tagname 
 
 
select distinct TagName as new, *,(REPLACE(TagName,' ','-')) as SeoProduct_Name from dbo.tbl_Image_Master inner join dbo.tbl_size on tbl_size.Size_Id=tbl_Image_Master.Size_Id inner join tbl_category on tbl_category.Cat_Id = tbl_Image_Master.Cat_Id

Answers (5)