How can We see last 50 Records of a Table?
Select top 50 from YourTableName order by YourIdColumn desc
SELECT * FROM table_name ORDER BY id DESC LIMIT 50;Note that this assumes that the table has a column named "id" that is used to order the records. If your table has a different column for ordering, you should replace "id" with the appropriate column name. Additionally, the order of the records can be changed from descending to ascending by changing the "DESC" keyword to "ASC".
Select Top 50 [Columns] from Table Order by [Column] desc
Answer submitted multiple times. Not sure why And I do not have option to delete this answer
Select top 50 with order by desc datecreated option…