I would Like to find repeats of "esn"
Query as follow:
SELECT ref_number,current_status,esn
FROM jobs
WHERE date_completed BETWEEN '2008-05-01' AND '2008-05-15'
I would like to find the repeats of esn for the previous months not only date_completed... thanks

SELECT ref_number,current_status,esn FROM jobs WHERE esn IN (
SELECT esn FROM jobs GROUP BY esn HAVING count(esnr)>1
)
;

However, I am not sure I understood correctly what you are trying to achieve.

HTH,

Dimitar

SELECT current_status,esn, count(*) AS total
FROM jobs
WHERE esn IN ('357666011363899','354932015183557')
GROUP BY current_status,esn
HAVING total>1

Results:

Sumthing like this..... I want to see the results of the ESN though
Pleeeeeeeeeeease help
I want it to display all 3 esn number not just summarising them in total