Hi
Could somebody help me with my sql query. Namely my table look as follow
dateline postid postwiews
122233 1 22
112333 2 43
122222 3 12
.....

I have a more record there by it don't matter now. What is confusing me is dateline. How can I construct a sql query to return the max number of postviews and average postviews for a particular date?
I know how to count all postviews in a table, but i have no idea how to count max postviews for specific date range for example post id:1 have the same date and how to return the max for this date.
Could somebody provide me some example???
Thanks in advance

The manual provides examples:
MySQL :: MySQL 5.5 Reference Manual :: 3.6.4 The Rows Holding the Group-wise Maximum of a Certain Column

Thanks for the reply
I am nearly find how to do my query but could somebody tell me how to sum the whole output from this query:

SELECT Sum(threadviews) as Total,
Max(threadviews) as Maximum
FROM
forum
WHERE dateline >= UNIX_TIMESTAMP('2012-09-18')
AND dateline < UNIX_TIMESTAMP('2012-11-18')
Group by dateline

it print me this table:

Total Maximum
11 11
10 3
17 13
12 6
0 0
0 0
11 9
3 2
3 2
2 2
0 0
1 1

Could somebody tell me how to sum the values from columns???
Thanks in advance

You should have a look at using AVG and MAX functions in a SELECT ... GROUP BY. In your case you need to group by the date.

Hi
What do you mean by avg and max in select? and the data is grouped by date(dateline). I am quite new so could I get some more information
Thanks

MySQL :: MySQL 5.0 Reference Manual :: 12.15.1 GROUP BY (Aggregate) Functions
or more specifcally
MySQL :: MySQL 5.0 Reference Manual :: 12.15.1 GROUP BY (Aggregate) Functions
MySQL :: MySQL 5.0 Reference Manual :: 12.15.1 GROUP BY (Aggregate) Functions

Ok i am loking for all the links but actually I can figered out how ot get the Total and miniumum but the max is not in the same range as max so could somebody make a suggestion where to include max for the sql above
Thanks

Hi
Any ideas how can i get the sum for this sql query:
SELECT Sum(threadviews) as Total,
Max(threadviews) as Maximum
FROM
forum
WHERE dateline >= UNIX_TIMESTAMP('2012-09-18')
AND dateline < UNIX_TIMESTAMP('2012-11-18')
Group by dateline

is returning the result but I don's know how to get the sum I will be appreciate for help
Thanks

Suggest you post what you Are getting and what you want for a result.

Data examples are most helpful.

Hi
there is my sql:
SELECT Sum(threadviews) as Total,
Max(threadviews) as Maximum
FROM
forum
WHERE dateline >= UNIX_TIMESTAMP('2012-09-18')
AND dateline < UNIX_TIMESTAMP('2012-11-18')
Group by dateline

it print me this table:

Total Maximum
11 11
10 3
17 13
12 6
0 0
0 0
11 9
3 2
3 2
2 2
0 0
1 1
But I would like to sum row, could somebody help me with this
Thanks