MySQL Forums
Forum List  »  Newbie

Re: SELECT, DATETIME and checking result counts
Posted by: Christian Page
Date: March 29, 2005 07:50AM

Chris,

The problem is that if one (or more) of the latest five hours have no records in the table, I want to skip this hour and go further back. By example, if hours 6,7,8,9,12 have records in the table, I want to retrieve hours 6,7,8,9,12, not just hours 8 to 12.

Options: ReplyQuote




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.