RES: SQL Select Idea [ORDER BY]

, 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 ... limit 10

RES: RES: RES: SQL Select Idea

: 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

RES: SQL Select Idea [ORDER BY]

]] 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

RES: RES: SQL Select Idea

]] 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

SQL Select Idea

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

MySQL: Select HELP!

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

RES: SQL Select Idea

: 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