i want to get unique md5 records that get added daily
requires counting records that are NOT IN .. have not been seen before
i'd like to get that by date going back for as long as I have data (say 90 days)
here are table fields
Table Details: imp_v18_20140916
query to modify is
count(DISTINCT md5) AS unique,
count(*) AS total_impressions
DATE_ADD(CURRENT_TIMESTAMP(), -90, 'DAY'),
GROUP BY date_new
ORDER BY date_new;
22 freelancer bu iş için ortalamada 22$ teklif veriyor
I have extensive experience with working on sql for last 10 years and have written even 6 pages long sql queries. I will not only match the output but also make the query give results really very fast.
Hello Dear Customer. I know how to solve this problem. But for the first: you write - "requires counting records that are NOT IN ..(please write a table where contains befor seen records) have not been seen befor"
Hi, I have overall 3 years of experience on java/j2ee ,spring, sql hibernate,Junit,Easymock technologies and also work with STS. I am a quick learner.
I believe it is a preety simple qeury. I might need more specific information to solve, but i can have it done in no time if you hire me. I work with SQL Server everyday.