TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
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
Reply
Answers (
5
)
Self Join? and how to write self join for more than 3 tables
select dropdwon list value change my url ???