Hi Michael,
Using two select's we already solved the problem. The challenge is to make
the same thing using just one select. I need to know if is there an way to
get the last date or the 10th index to make the WHERE part. Like the
LAST_INDEX() function, that gets the last AUTO_INCREMENT...but I
: 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, which you
Well, could you explain the behave of ORDER BY DATE,COD?
I will show you bellow what I want, graphically:
1) What I have:
Table: processo_arquivos
_
|Cod| Date |
-
|1 | 12/10 |
-
|2
]]
Enviada em: quarta-feira, 4 de dezembro de 2002 02:06
Para: [EMAIL PROTECTED]
Assunto: Re: RES: SQL Select Idea
On Tue, Dec 03, 2002 at 07:02:02PM -0200, Felipe Moreno - MAILING LISTS
wrote:
2) What I get is I use the SELECT * FROM processo_arquivos ORDER BY DATE
DESC LIMIT 0,3 (considering
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 Jim and others that tried to help me!
Thanks for any kind os answer.
Well, the SQL command that you suggested don't work for me. Below, I will
show What I want and what I get if I use the select command you suggested:
1) What I have:
Table: processo_arquivos
_
On Tue, Dec 03, 2002 at 07:02:02PM -0200, Felipe Moreno - MAILING LISTS wrote:
2) What I get is I use the SELECT * FROM processo_arquivos ORDER BY DATE
DESC LIMIT 0,3 (considering that I only want 3)
[ that worked as described ]
3) The problem getting the result like this:
Since I have a