select distinct value with all column

Question

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

Khan Abrar Ahmed · Answer

Hi Distinct will not work with * becuase * means select all the column from table along with joins table column and if you have any modified date or any auditing column it will select those columns also please check your script instead of using * use only those column which is required.

Krishna Rajput Singh · Answer

Hi Devendra Kumar thanks for writing below links i hope helpful for you. http://www.w3schools.com/sql/sql_distinct.asp http://stackoverflow.com/questions/6127338/sql-mysql-select-distinct-unique-but-return-all-columns https://blog.udemy.com/select-distinct/ http://www.dofactory.com/sql/select-distinct if find answer as helpful mark as correct

Gowtham Rajamanickam · Answer

http://www.techonthenet.com/sql/distinct.php

Gowtham Rajamanickam · Answer

http://www.tutorialspoint.com/sql/sql-distinct-keyword.htm

Gowtham Rajamanickam · Answer

Refer thishttp://www.w3schools.com/sql/sql_distinct.asp