List:General Discussion« Previous MessageNext Message »
From:Jim Esten Date:December 4 2002 12:22am
Subject:RE: SQL Select Idea
View as plain text  
Is anyone else experiencing long delays in posts?  I sent this about 5
hours before it posted.

Thanks,

Jim

-----Original Message-----
From: Jim Esten [mailto:jesten@stripped] 
Sent: Tuesday, December 03, 2002 1:40 PM
To: 'Felipe Moreno - MAILING LISTS'; mysql@stripped
Subject: 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 it..

Jim

Jim Esten
Chief Techbot
WebDynamic  http://www.wdynamic.com

-----Original Message-----
From: Felipe Moreno - MAILING LISTS [mailto:ml@stripped] 
Sent: Tuesday, December 03, 2002 10:39 AM
To: mysql@stripped
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 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


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <mysql-thread126423@stripped>
To unsubscribe, e-mail
<mysql-unsubscribe-jesten=wdynamic.com@stripped>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <mysql-thread126449@stripped>
To unsubscribe, e-mail
<mysql-unsubscribe-jesten=wdynamic.com@stripped>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

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