: SQL Select Idea
On Wed, Dec 04, 2002 at 08:55:51AM -0200, Felipe Moreno - MAILING LISTS
wrote:
>Well, the SQL Query you requested is exatcly the one I'm asking! :-)
No; I want to know what you intended for those 10 dates to do. The LIMIT
query
worked, as posted by someone else, w
On Wed, Dec 04, 2002 at 08:55:51AM -0200, Felipe Moreno - MAILING LISTS wrote:
>Well, the SQL Query you requested is exatcly the one I'm asking! :-)
No; I want to know what you intended for those 10 dates to do. The LIMIT query
worked, as posted by someone else, which you quoted. What do you
Hi Michael,
Well, the SQL Query you requested is exatcly the one I'm asking! :-)
Like I said in other message, I solved the problem using TWO queries. In
the first one I get the 10th date. In the second one I use this date to
LIMIT the result to what I want. But is not a question of solving
Hi Doug,
First, thanks for the idea. Well, We solved the problem using 2 selects.
Actually I was doing what you suggested. I used a "little" select using
limit 0,10 and got the last DATE value. So, with this value I can construct
the WHERE part easily of the second select. it's working fine, but,
