65. Retrieving the Last Record in Each Group

This advanced SQL exercise is part of the book: Advanced SQL – Practical Techniques and Use-Cases, which includes 100 day-to-day SQL challenges (and solutions), need-to-know advanced features, and key concepts.
 

Given a table that specifies various messages sent between users in an organization. Each row contains the message number, the sending date, and the message’s content, sorted by the sending date:

CREATE TABLE [messages]
(message_id int identity(1,1),
message_date date,
message_context varchar(25))
GO

To read more

Log In

Register