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
Pinku
1.4k
308
46.9k
Not Taking the Distinct value
May 14 2019 12:26 AM
select distinct HHU.FirstName, HHU.LastName , HHU.Email as UserEmail, HHU.Created as UserCreateDate, HHU.LastLogin , HHR.JobTitle as ResumeTitle, hhr.did,hhr.Created as ResumeCreatedDate,reh.EndDateText as LastTitleEndDate,kd.ONet17 as Onet
from SiteData.hhtvuser HHU
inner join ResumeData.hhresume HHR on HHR.UserDID = HHU.DID
inner join ResumeData.ResumeEmploymentHistory reh on HHR.DID = reh.ResumeDID
inner join knowledgediscovery.resumeevidence kd on HHR.DID = kd.resumedid
where HHU.ClassList like '%RPSW%' AND hhu.created>= '2019-04-01' order by reh.enddatetext desc limit 1000000
I want that resume did should be distinct along with all distinct.How can i do it. This query retuen no distinct value
Reply
Answers (
2
)
DateTime Format in SQL
A SELECT with INNER JOIN don’t works