Last xx Records

[DaRTHY]

Hello Friends

I need a simple query for my last xx record. I checked from internet mostly i can see first or top xx record option. I want to see my last xx records.

for example 10 records. but my last 10 saved records.... my last id 100 i want to see around 90-100 or i have 200 records thats mean i want to see around 190-200.

Ty for your helps !

 

[JHB]

Use the TOP predicate in your query + descending sort order.
The link shows how to use it:
https://support.office.com/en-sg/ar...edicates-24f2a47d-a803-4c7c-8e81-756fe298ce57

 

[DaRTHY]

but it shows TOP thats mean my first around 1 to 10 records. I want to see last 10 thats mean around 90 to 100

 

[JHB]

Therefore the descending sort order, then you'll get them from the bottom.

 

[DaRTHY]

LoL thanks mate i dont know why i did´t think on this option everytime i used "Ascending"

 

[JHB]

Then it is time to learn something new.
Good luck!