How can We see last 50 Records of a Table?

Rajeev Kumar

4.8k

Select Top 50 Column_Name from Table Order by Column_Name desc

Pavan Ramamurthy

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.

Tuhin Paul

Select top 50 from YourTableName order by YourIdColumn desc

Jignesh Kumar

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".

Manoj Kumar Duraisamy

Select Top 50 [Columns] from Table Order by [Column] desc

Munib Butt

Answer submitted multiple times. Not sure why And I do not have option to delete this answer

Jignesh Kumar

Select top 50 with order by desc datecreated option…

Aravind Govindaraj

Insert Link

Embed YouTube Video

Table Options

Insert Image