I have been given what is effectively a flat-file database which needs converting to a relational database Ie the current (sole) table could look like this:

Ticket no description
123 original problem
123 a contact with user
123 the solution
124 a new problem
124 the solution

etc

What the user wants is to query this database to ONLY get the last record for each problem ticket?

Any ideas much apreciated