Not Taking the Distinct value

Pinku

7y763

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

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Madan Shekar7y ago
Accepted answer
Hi,

If the SELECT clause contains more than one field, the combination of values from all fields must be unique for a given record to be included in the results. The output of a query that uses DISTINCT is not updateable and does not reflect subsequent changes made by other users.

TRY with "DISTINCTROW"

instead of distinc use DISTINCTROW

Omits data based on entire duplicate records, not just duplicate fields. For example, you could create a query that joins the Customers and Orders tables on the CustomerID field. The Customers table contains no duplicate CustomerID fields, but the Orders table does because each customer can have many orders. The following SQL statement shows how you can use DISTINCTROW to produce a list of companies that have at least one order but without any details about those orders:

If it helps pls mark as answer
0
Rajanikant Hawaldar7y ago
Hi manas,
if possible post table with data

instead of '%RPSW%' use '%RPSW' and check

or

use having clause
0