In a table containing records of all customer with there orders and status of deliveries. Now I wish to find only last the entry of each customer available this table, it can be their last order or delivery status. What would be the ideal query for this? Please help me.

do you store the order datatime as well ?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.