List:General Discussion« Previous MessageNext Message »
From:Felipe Moreno - MAILING LISTS Date:December 3 2002 4:38pm
Subject:SQL Select Idea
View as plain text  
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 only the last TEN. How Can I do this? Any
ideia? I tried the sql bellow o archive this, but I was unable to do it. I
just want to do this with ONLY one select, not with two.

Thanks for any idea.

Regards,

Felipe
Thread
• Blob accepts LongBlob without errorRyan @ Common Ground . To3 Dec
  • re: Blob accepts LongBlob without errorVictoria Reznichenko3 Dec
    • SQL Select IdeaFelipe Moreno - MAILING LISTS3 Dec
      • RE: SQL Select IdeaMike Hillyer3 Dec
      • RE: SQL Select IdeaJim Esten3 Dec
        • RES: SQL Select IdeaFelipe Moreno - MAILING LISTS3 Dec
          • Re: RES: SQL Select IdeaMichael T. Babcock4 Dec
            • RES: RES: SQL Select IdeaFelipe Moreno - MAILING LISTS4 Dec
              • Re: RES: RES: SQL Select IdeaMichael T. Babcock4 Dec
                • RES: RES: RES: SQL Select IdeaFelipe Moreno - MAILING LISTS5 Dec
        • RE: SQL Select IdeaJim Esten4 Dec
• Re: Blob accepts LongBlob without errorJan Steinman3 Dec