subject:"RES\: SQL Select Idea \[ORDER BY\]"

RES: SQL Select Idea [ORDER BY]

2002-12-06 Thread Felipe Moreno - MAILING LISTS

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

RES: SQL Select Idea [ORDER BY]

2002-12-05 Thread Felipe Moreno - MAILING LISTS

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