Showing last 5 entries

Databases
1

Hello

I want to display the last five entries however I want it be ordered ASC.

e.g say this is my table data

1,2,3,4,5,6,7,8,9,10

I want it display

6
7
8
9
10

2

select id, whatever, else, from table
order by id desc
limit 5

then use php to reorder the data when displayed.

3

Hi thank you for your response. I want to order it ASC and show the last 5 results.

Simply using
“order by id ASC / DESC
limit 5”
will not be the desired result.

4

please read the last line of dr john’s post

5 
SELECT * FROM
   (SELECT * FROM yourtable
   ORDER BY yourcolumn DESC
   LIMIT 5)
ORDER BY yourcolumn
6

that needs a table alias, guelphdad :wink:

7

Don’t you need to distinguish between the 2 yourcolumn references?

8

… the 2 yourcolumn references?

9

Hello sorry, i would like to know if it is possible through mysql

10 
SELECT * FROM   
   (SELECT *
   FROM yourtable   
   ORDER BY yourcolumn DESC  
   LIMIT 5) as DT
ORDER  BY yourcolumn