ORDER BY whatever DESC LIMIT 100
Mark S Lowe wrote:
>Is there a nifty way to select just that last 100 records with MySQL? In
>Oracle I use Maxrows and date to accomplish this. Can¹t seem to figure this
>out with MySQL.
>
>Please advise! Thank you!
>
>Mark
>
-
In the last episode (Jun 25), Mark S Lowe said:
> Is there a nifty way to select just that last 100 records with MySQL? In
> Oracle I use Maxrows and date to accomplish this. Can?t seem to figure this
> out with MySQL.
You mean "select the 100 most-recently-inserted records" ?
SELECT * FROM tab
: "Mark S Lowe" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, June 25, 2002 12:19 PM
Subject: Need last 100 records...
Is there a nifty way to select just that last 100 records with MySQL? In
Oracle I use Maxrows and date to accomplish this. Can¹t seem to figu
Use Limit is one way
On 6/25/02 12:19 PM, "Mark S Lowe" <[EMAIL PROTECTED]> wrote:
> Is there a nifty way to select just that last 100 records with MySQL? In
> Oracle I use Maxrows and date to accomplish this. Can¹t seem to figure this
> out with MySQL.
>
> Please advise! Thank you!
>
> M
Mark S Lowe wrote:
>
> Is there a nifty way to select just that last 100 records with MySQL? In
> Oracle I use Maxrows and date to accomplish this. Can¹t seem to figure this
> out with MySQL.
>
> Please advise! Thank you!
>
> Mark
SELECT * FROM SOME_TABLE
ORDER BY SOME_KEY
LIMIT 0,100
Van
--
Is there a nifty way to select just that last 100 records with MySQL? In
Oracle I use Maxrows and date to accomplish this. Can¹t seem to figure this
out with MySQL.
Please advise! Thank you!
Mark
