Kapalı

simple sql query modification

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

date_time STRING

ip STRING

country STRING

region STRING

zip STRING

request_uri STRING

referer STRING

useragent STRING

uuid STRING

md5 STRING

query to modify is

SELECT

DATE(date_time)

AS date_new,

count(DISTINCT md5) AS unique,

count(*) AS total_impressions

FROM

TABLE_DATE_RANGE(li.imp_v18_,

DATE_ADD(CURRENT_TIMESTAMP(), -90, 'DAY'),

CURRENT_TIMESTAMP())

GROUP BY date_new

ORDER BY date_new;

Beceriler: SQL

Daha fazlasını görün: sql get date, sql query, sql select order, referer string, string md5, modify query, modification referer, sql query modification, simple sql, useragent, zip query, sql country region, uuid, md5 string, sql query date, sql day, sql back, order date sql query, modify fields sql, country region town sql, back sql, referer modification, parent child query sql, query sql 2005 csv, country region database

İşveren Hakkında:
( 8 değerlendirme ) nashville, United States

Proje NO: #6523344

22 freelancer bu iş için ortalamada 22$ teklif veriyor

LearningNew

A proposal has not yet been provided

1 gün içinde 24$ USD
(17 Değerlendirme)
5.6
schungur

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 fazlası

1 gün içinde 35$ USD
(9 Değerlendirme)
4.9
waqas7803

Looking forward to do this for you now. ...............................................................

1 gün içinde 25$ USD
(7 Değerlendirme)
3.3
Windowfreak1985

A proposal has not yet been provided

1 gün içinde 24$ USD
(2 Değerlendirme)
3.2
danangvw

I have bachelor and master degrees in IT. My Primary skills include Java, Python, VB/.NET, Delphi, and PHP. Also database skills include MS Access, MySQL, and Oracle. My Other skills include server and network administ Daha fazlası

1 gün içinde 10$ USD
(6 Değerlendirme)
1.1
bhagyarajpillai

A proposal has not yet been provided

1 gün içinde 25$ USD
(0 Değerlendirme)
0.0
omvineet

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.

1 gün içinde 25$ USD
(0 Değerlendirme)
0.0
ewway

skype id kang.ajay.singh 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 fazlası

1 gün içinde 10$ USD
(0 Değerlendirme)
0.0
anilnie2010

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 fazlası

1 gün içinde 20$ USD
(0 Değerlendirme)
0.0
shanthuprabu

I can give u in 1 hour or before one day if needed.. if needed contact me on saturday tomorrow and sunday .

1 gün içinde 25$ USD
(0 Değerlendirme)
0.0
shiva6465

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 fazlası

1 gün içinde 35$ USD
(0 Değerlendirme)
0.0
joshuav1972

A proposal has not yet been provided

1 gün içinde 25$ USD
(0 Değerlendirme)
0.0
dennyslemos84

A proposal has not yet been provided

1 gün içinde 15$ USD
(0 Değerlendirme)
0.0
bmitsan

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"

in 0 gün içinde15$ USD
(0 Değerlendirme)
0.0
pramodv

I have 10+ years experience of software development using Foxpro2.6(dos), Visual Foxpro 6 & 9, SQL Server 2000,2005,2008, C#, ASP.Net, MVC, Crystal Reports,MySql, HTML, CSS, JavaScript, jQuery, jQuery UI, Bootstrap, Daha fazlası

in 4 gün içinde20$ USD
(0 Değerlendirme)
0.0
maheshtippani

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.

1 gün içinde 20$ USD
(0 Değerlendirme)
0.0
vivekanandjoshi

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 fazlası

1 gün içinde 20$ USD
(0 Değerlendirme)
0.0
Alethor

La propuesta todavía no ha sido proveída

in 2 gün içinde20$ USD
(0 Değerlendirme)
0.0
vw1077012vw

A proposal has not yet been provided

1 gün içinde 25$ USD
(0 Değerlendirme)
0.0
starbuck753

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.

1 gün içinde 17$ USD
(0 Değerlendirme)
0.0