how to get the updated changes and the last update in the new table when we update from data table to new table
Budget: ₹600 – ₹1,500 INR
Create 2 tables one is data table other is the new table, when i insert or update any new change in the data table it should reflect in the new table. it should show the new change and also the last change. The query should not use any triggers and also no system versioning
Related categories:
MySQL
PostgreSQL
Microsoft SQL Server
SSIS (SQL Server Integration Services)
NoSQL