select records by latest date

charles07

how can i get records by the latest date. ie. select last inserted records. mysql db structure below

Expand|Select|Wrap|Line Numbers

 timestamp  method  id comment

2009-01-10 getThud 16 "....."

2009-01-10 getFoo  12 "....."

2009-01-10 getBar  12 "....."

2009-01-11 getFoo  12 "....."

2009-01-11 getBar  12 "....."

desired results

Expand|Select|Wrap|Line Numbers

 timestamp  method  id comment

2009-01-10 getThud 16 "....."

2009-01-11 getFoo  12 "....."

2009-01-11 getBar  12 "....."

I used below code, iam not sure whether it's the right approach.

Expand|Select|Wrap|Line Numbers

 select max(timestamp),method,id from tables where 1 group by method,id order by timestamp desc 
 

charles07

wooooooooow, i tried this, it's working

Expand|Select|Wrap|Line Numbers

 SELECT a.`timestamp`,a.`method`,a.`id`,d.`studentname`

FROM `schools` a

INNER JOIN `schoolstudent` d ON a.`studentid`=d.`studentid`

WHERE a.`pid` IN (

    SELECT MAX(`pid`)

    FROM `schools`

    GROUP BY `method`,`id`,`order`

) 

ORDER BY a.`id` ASC;

select records by latest date

Post your reply

Similar topics

Question stats

	Ask Question
Home Questions Articles Browse Topics Latest Top Members FAQ