how to get last 10 records form sql table in asc order

Question

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

Accepted Answer

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

Solution