Get latest data from SQL based on date or ID

Question

How can I get the latest data from this query, actually the table is crowded and we need the latest data from the last 2 years, how can I modify my query accordingly. Select stagingScriptDB.*, testBedSuiteMapping.template from stagingScriptDB inner join testBedSuiteMapping on testBedSuiteMapping.id=stagingScriptDB.idScriptDBlimit10;

P粉464113078 · Answer

It would be great if you share the table structure.

We can use this query type to retrieve the last record of id

SELECT * FROM table_name
WHERE ID IN (
  SELECT max(ID) FROM table_name
  GROUP BY column_name
  ORDER BY column_name
)