sql - Select all the data from a table where the timestamp against each customer_id is maximum

Question

The data is as follows and each cust_id (customer id) may or may not have multiple rows of data. Just as a sample data I have created the following. I want to write a SQL query to get all the data of each cust_id (customer id) where the timestamp is latest.

Cust_id	name	visit_date
1	"AB"	"2000-01-22 21:00:00.000000"
1	"AB1"	"2000-01-22 22:00:00.000000"
2	"MN"	"2000-01-22 22:00:00.000000"
2	"MN1"	"2000-01-22 21:00:00.000000"
3	"XY"	"2000-01-22 22:00:00.000000"
3	"XY1"	"2000-01-22 21:00:00.000000"
4	"HI"	"2000-01-22 21:00:00.000000"

question from:https://stackoverflow.com/questions/65851148/select-all-the-data-from-a-table-where-the-timestamp-against-each-customer-id-is

Answer 1

A canonical method is:

select te.*
from time_entry te
where te.visit_date = (select max(te2.visit_date)
                       from time_entry te2
                       where te2.cust_id = te.cust_id
                      );