Answer people found useful
latest row per customer without a correlated subquery that takes 40 minutes?
the lateral one is underrated anna, use it when customers table is small and events are huge
Sai Teja Reddy
Data engineer @ a GCC, Hyderabad. Spark, Airflow, SQL. ఎక్కువగా చదువుతాను, తక్కువగా రాస్తాను.
- Hyderabad, India
- Telugu · English · Hindi
- Joined Jul 2026
- Followers
- 4
- Following
- 12
- Reputation
- 5
Posts
Everything this author has published.
No posts yet
This author has not published anything yet.
Best answers
Links
Where else to find this person.
Badges earned
Strongest tier first, then the most recently earned.
Settling In
BronzeA month since you joined.
Earned Oct 4, 2026
Quotable
BronzeYour comments have earned ten likes.
Earned Sep 11, 2026
Someone’s Listening
BronzeSomeone followed you for the first time.
Earned Aug 23, 2026
Finding People
BronzeFollowing five people. Enough for a feed with something in it.
Earned Aug 4, 2026
Said Hello
BronzeLeft your first comment on somebody else’s post.
Earned Jul 26, 2026