Reporting how to SQL - LIMIT BY 1 ?

[billster]

Hello,

I am running a report and I want to do a LIMIT BY 1 to get the latest record in the table as it is pulling through every record there is (per Request ID). I want to have only the record which is circled in blue.

 

here is how I am getting the report...

 

[Jim]

(select h_pk_updateid as test from h_itsm_requesthistupdates
WHERE h_itsm_requests.h_pk_reference = h_itsm_requesthistupdates.h_fk_reference
Order by h_pk_updateid desc
Limit 1)

 

[billster]

32 minutes ago, Jim said:

(select h_pk_updateid as test from h_itsm_requesthistupdates
WHERE h_itsm_requests.h_pk_reference = h_itsm_requesthistupdates.h_fk_reference
Order by h_pk_updateid desc
Limit 1)

 

perfect, works a treat