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;
21 freelancers are bidding on average $22 for this job
THE TOP SQL FREELANCER AT YOUR SERVICE... PLEASE CHECK MY BADGES, PROJECTS AND REVIEWS and ensure yourself that I can do this very well and very quick... Please note my SQL Level3 Badge... it makes me the TOP SQL Freel Daha Fazla
Looking forward to do this for you now. ...............................................................
Can do it right now. Please let me know if you want me to work on it right now and give yo the required query. Thanks, Ayan Dasgupta.
skype id [url removed, login to view] I have been working as DBA from the last 10 years, with Oracle, SQL Server, MySQL. I was in a lot of big projects for big enterprises like Apple,EA, Medtranics, IBM, TCS, DB, Orange etc.. Daha Fazla
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 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.
I have strong background in sql,pl/sql programming. Gained lot of confidence while working for Capgemini india pvt. ltd. in various mnc projects. I am confident that i am going to complete the task with perfection. Daha Fazla
I can give u in 1 hour or before one day if needed.. if needed contact me on saturday tomorrow and sunday .
I have over 8 years of experience as a MS SQL Server database developer. Experienced with scripting in T-SQL in constructing tables, inner/outer joins, user functions, views and indexes. Wrote many Stored Procedures Daha Fazla
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"
I can do this in the least rate here.. I am a new free lancer and I am doing projects for reputation. Money doesn't matter much to me right now. Please award me this project and give the money only if you are happy wit Daha Fazla
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.