Welcome Guest, Not a member yet? Register   Sign In
How do I get the last 3 records in a table?
#2

[eluser]alekz[/eluser]
Try This!!

Code:
SELECT * FROM products ORDER BY product_id DESC LIMIT 3

Limit gives you the first three rows

i hope this can help you....


Messages In This Thread
How do I get the last 3 records in a table? - by El Forum - 06-02-2008, 06:49 AM
How do I get the last 3 records in a table? - by El Forum - 06-02-2008, 08:06 AM
How do I get the last 3 records in a table? - by El Forum - 06-02-2008, 08:20 AM



Theme © iAndrew 2016 - Forum software by © MyBB