"SELECT * FROM proyects WHERE proyect_num >= MAX(pro
Posted: Sat Feb 26, 2005 11:57 am
Help, I have a table called proyects with this fields:
proyect_num | date_added | filename | description | title
proyect_num is a auto_increment.
but I want to do something like this:
So i want to select the last 5 proyect_num's, how can I do that?
proyect_num | date_added | filename | description | title
proyect_num is a auto_increment.
but I want to do something like this:
Code: Select all
"SELECT * FROM proyects WHERE proyect_num >= MAX(proyect_num) - 5"