How to get last 10 records from sql table in ascending order

Question

select top(10) from customer order by customer_id desc

Answer 1

select * 
from (select top 10 * from customer order by customer_id desc) a
order by  customer_id

Answer 2

This work works fine in MS SQL, but for MySQL we have to go SELECT * FROM customer ORDER BY customer_id DESC LIMIT 10

Answer 3

It seems you are missing the list of columns that you want to get from the table.

Consider:

select top(10) 
*
from customer order by customer_id desc

or

select top(10) 
customer_id, customer_name
from customer order by customer_id desc

Answer 4

you can use: SELECT * FROM customer ORDER BY customer_id DESC LIMIT 10