just saw
apllacation using the update command. Well, any new ideas?
Best Regards,
Felipe
-Mensagem original-
De: Michael T. Babcock [mailto:[EMAIL PROTECTED]]
Enviada em: quinta-feira, 5 de dezembro de 2002 21:03
Para: [EMAIL PROTECTED]
Assunto: Re: SQL Select Idea [ORDER BY]
On Thu
: 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
On Thu, Dec 05, 2002 at 09:41:24AM -0200, Felipe Moreno - MAILING LISTS wrote:
The ten last dates appear as a default result of a Archives page. When I
enter for the first time in the page, it give me the last ten Files that was
uploaded. In the same page, I can ORDER BY the ten last dates
]]
Enviada em: quinta-feira, 5 de dezembro de 2002 16:02
Para: [EMAIL PROTECTED]
Assunto: Re: SQL Select Idea [ORDER BY]
On Thu, Dec 05, 2002 at 09:41:24AM -0200, Felipe Moreno - MAILING LISTS
wrote:
The ten last dates appear as a default result of a Archives page. When
I
enter for the first
On Thu, Dec 05, 2002 at 08:54:29PM -0200, Felipe Moreno - MAILING LISTS wrote:
Well, could you explain the behave of ORDER BY DATE,COD?
Just try it (it will order by date, then cod).
What I think you want is (as I originally said, but briefly):
create temporary table top10 select * from ...
]]
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 List Users,
I want to know if anyone has any idea on how can I do the SQL command
below to archive a result.
I have one table called processo_arquivos that have a filed called DATE
and another FIELD called COD (primary key). I want to select the last TEN
(10) dates from the Database, but
I believe that
SELECT * FROM processo_arquivos ORDER BY date DESC LIMIT 10;
Should do it.
Mike Hillyer
-Original Message-
From: Felipe Moreno - MAILING LISTS [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 03, 2002 9:39 AM
To: [EMAIL PROTECTED]
Subject: SQL Select Idea
Importance
, December 03, 2002 10:39 AM
To: [EMAIL PROTECTED]
Subject: SQL Select Idea
Importance: High
Hi List Users,
I want to know if anyone has any idea on how can I do the SQL command
below to archive a result.
I have one table called processo_arquivos that have a filed called
DATE and another
: Jim Esten [mailto:[EMAIL PROTECTED]]
Enviada em: terça-feira, 3 de dezembro de 2002 17:40
Para: 'Felipe Moreno - MAILING LISTS'; [EMAIL PROTECTED]
Assunto: RE: SQL Select Idea
Something on the order of...
SELECT * FROM processo_arquivos ORDER BY DATE DESC LIMIT 0,10
Seems like that ought to do
: Tuesday, December 03, 2002 10:39 AM
To: [EMAIL PROTECTED]
Subject: SQL Select Idea
Importance: High
Hi List Users,
I want to know if anyone has any idea on how can I do the SQL command
below to archive a result.
I have one table called processo_arquivos that have a filed called
DATE
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
13 matches
Mail list logo