Well if Flag is in your table, then you just need
Select Person, Action, Date From YourTableName Where flag = 'Y' Order By Date
But you say Flag isn't in your table, in which case you have to tell us what the algorithm is for deciding which rows you want.
Also, let us know which release of SQL Server you are using.
Tom
No comments:
Post a Comment