RES: SQL Select Idea [ORDER BY]

2002-12-06 Thread Felipe Moreno - MAILING LISTS
but I 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] O

Re: SQL Select Idea [ORDER BY]

2002-12-05 Thread Michael T. Babcock
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 ..

RES: SQL Select Idea [ORDER BY]

2002-12-05 Thread Felipe Moreno - MAILING LISTS
ten dates). So, >what I really need ia an way to make a select without any "data" from the >DB. I tried to use de LAST_INDEX() function to do this but I didn't go >anywhere. Any ideas??? -Mensagem original- De: Michael T. Babcock [mailto:[EMAIL PROTECTED]] Enviada em: quinta-feira,

Re: SQL Select Idea [ORDER BY]

2002-12-05 Thread Michael T. Babcock
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