distinct first column... the rest not

[matchoo]

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)

[bubblegum.anarchy]

Grab all the records on the condition of the 'certain day' ordered by the date and limit 1.

[Illusion]

select MAX(date_stamp),page, hits from log where date='give-date'

I am not sure of it, if it doesn't work try using concatenating date_stamp with a integer or a string and use MAX().

[matchoo]

Can't do that because it's for multiple days.

 

To clarify.  I want the last entered hit count per day, for each day.  Not for one day... a list of days.

[Illusion]

elect MAX(date_stamp),page, hits from log where date=ALL (select DISTINCT date from log)