MySQL Forums
Forum List  »  Newbie

Re: query question
Posted by: JOHN FARRUGIA
Date: April 13, 2005 10:57AM

This almost works:

select * from data_readings.lts4a_line where timestamp(readtime)<'2005-04-12 16:30' group by reference order by id desc;

But the first items in the table satisfy this query. I want the query to retrieve the first enrties below this time. Any suggestions?

Options: ReplyQuote


Subject
Written By
Posted
April 13, 2005 06:24AM
Re: query question
April 13, 2005 10:57AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.