Sql query problem

Dev Shed Forums Sponsor:

December 4th, 2012, 06:23 AM

zubair_h

Registered User

Join Date: Feb 2010

Posts: 18

Time spent in forums: 3 h 17 m 35 sec
Reputation Power: 0

Sql query problem

Hi,

I have the following query:

select * from thegroup_pageviews
where date >= '2012-12-02'
and date <= '2012-12-03'

This query brings back following sample data from the table (first row is header info):

title - views - date
Home1 - 4 - 2012-12-02
About Us - 3 - 2012-12-03
Contact - 2 - 2012-12-02
Reports - 5 - 2012-12-03
About Us- 6 - 2012-12-02
Home1- 7 - 2012-12-03
Contact- 3- 2012-12-03

Is there a way to write a query using specific date range that groups by the title? So for example if I would get distinct title with the sum of views for date range specified? So the query would then bring back following data for same date range as above

title - views
Home1 - 11
About Us - 9
Contact - 5
Reports - 5

Any help would be appreciated.

Thanks

December 4th, 2012, 06:51 AM

Jacques1

pollyanna

Join Date: Jul 2012

Location: Germany

Posts: 2,042

Time spent in forums: 1 Month 3 Weeks 1 h 40 m 17 sec
Reputation Power: 812

Hi,

Quote:

Originally Posted by zubair_h

Is there a way to write a query using specific date range that groups by the title? So for example if I would get distinct title with the sum of views for date range specified?

Um, all you have to do is translate your question into an SQL query:

Code:

SELECT
	`title`
	, SUM(`views`)
FROM
	`thegroup_pageviews`
WHERE
	`date` BETWEEN '2012-12-02' AND '2012-12-03'
GROUP BY
	`title`

December 4th, 2012, 07:03 AM

zubair_h

Registered User

Join Date: Feb 2010

Posts: 18

Time spent in forums: 3 h 17 m 35 sec
Reputation Power: 0

oh thanks! I'm not too familiar with sql yet. Looks simple enough!

Viewing: Dev Shed Forums > Databases > MySQL Help > Sql query problem

« Previous Thread | Next Thread »

Developer Shed Advertisers and Affiliates

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox

Forum Jump