How can We see last 50 Records of a Table?
Rajeev Kumar
Select Top 50 Column_Name from Table Order by Column_Name desc
To see the last 50 records of a table in SQL Server, you can use the TOP clause in combination with the ORDER BY clause to sort the records in descending order based on the primary key or any other column that defines the order of records in the table.
SELECT TOP 50 * FROM my_table ORDER BY id DESC;
This query selects the top 50 records from the my_table table and sorts the records in descending order based on the id column, which is assumed to be a primary key that defines the order of records in the 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…