Results 1 to 2 of 2
Dec 1, 2009, 10:11 #1
- Join Date
- Dec 2004
- 0 Post(s)
- 0 Thread(s)
How get last 5 records (in ASC order)
Say I have a data field I am sorting by with the following values 1,2,3,4,5,6,7,8,9,10.
If I were to limit 5 I would get 1,2,3,4,5
If I were to limit 5 and order desc I would get 10,9,8,7,6
What I want to get is 6,7,8,9,10
Does anyone know a good way to limit a search to the last 5 records while keeping the data in ASC order in MySql?