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: sql get date, SQL Query, sql select order, referer string, string md5, modify query, modification referer, sql query modification, simple sql, useragent, simple delete query sql php, zip query, sql country region, uuid, sql query sql query, md5 string, sql query date, sql day, sql back, order date sql query, modify fields sql, country region town sql, back sql, request_uri, referer modification

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

Proje NO: #6523344

Bu iş için 21 freelancer ortalamada $22 teklif veriyor

LearningNew

A proposal has not yet been provided

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(17 Değerlendirme)
5.7
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 Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(10 Değerlendirme)
5.1
waqas7803

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(7 Değerlendirme)
3.3
Windowfreak1985

A proposal has not yet been provided

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(2 Değerlendirme)
3.2
ayandgpt

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.

in %bids___i_period_sub_35% gün içinde25%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)
3.2
Alethor

La propuesta todavía no ha sido proveída

in %bids___i_period_sub_35% gün içinde20%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)
1.0
ewway

skype id [login to view URL] 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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(1 Yorum)
0.4
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 %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(1 Yorum)
0.4
joshuav1972

A proposal has not yet been provided

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% 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 %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% 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 Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% 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 %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% 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 Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
dennyslemos84

A proposal has not yet been provided

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
bhagyarajpillai

A proposal has not yet been provided

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% 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 %bids___i_period_sub_35% gün içinde15%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(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 Fazla

in %bids___i_period_sub_35% gün içinde20%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(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 Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
vw1077012vw

A proposal has not yet been provided

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% 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 %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0