distinct date, but not distinct otherwise...

[mreider]

Hi there,

I have a log file with multiple records per day.

I want to get the last log entry per page for a certain day only.

select distinct date_stamp, page, hits from log

won't work because there are different hit counts - so the query returns duplicate entries for a page

how to get the last timestamp per day?

(p.s. - I'm on 4.1 not 5)

[bogu]

SELECT page, SUM(hits) FROM log
WHERE date_stamp = "certain_day"
GROUP BY page

Something like this, I didn`t understand exactly what u need ...