Skip to main content
Admissions guidance, study banks, and career tools — get started on Shalyam

Latest Record per User

For every user return the most recent address and its update time. Order by user_id.

Table schema

AddressChanges(id INT PRIMARY KEY, user_id INT, address VARCHAR(20), updated_at DATE)

Sample data

id | user_id | address | updated_at
1 | 1 | Pune | 2026-01-01
2 | 1 | Mumbai | 2026-03-01
3 | 2 | Delhi | 2026-02-01
4 | 2 | Agra | 2026-01-15

Discussion

No discussions yet.

Rewards · v2.1

Get Exclusive Insights with Every Issue

Join Shalyam Newsletter

Stay ahead in education, research, and innovation—straight to your inbox.