I have a table with data entry like below. I want to select the last 5 rows all the time when new data will be inserted. So, product_id 2-6 will be selected in here. But when I will enter a new product, id 3-7 will be selected and afterwards.. What will be SQL query for this? I am newbie. Any help will be greatly appreciated. Thanks in advance.
x
product_id product_name product_price
------------------------------------------
1 Phone 120
2 Chips 2
3 Television 300
4 PC 400
5 Radio 50
6 Watch 10
Advertisement
Answer
You can use the below query assuming that “product_id” is incremental as the new rows get added.
Select * from table_name order by product_id DESC limit 5.
Explanation: The query will sort the rows based on product_id in descending order and limit 5 will Limit the output to 5 from first row. So even a new row is added the query will give you the last five rows.
Hope it helps. Thanks