asked on
Hi Experts,
I have a table named HistoryChanges with following fields
ID (PK) Int Auto num
Initial varchar (5)
DateEntered DateTime
Other columns are not relevant
Would like to get all records from a given initial which were entered latest.
Meaning if Initial A entered first 5 records then Initial B entered another 5, later Initial A entered 2 records,
If I'm looking for Initial A I would only want see the last two records, while if searching for Initial B I would want see 5 records.
This could be determined either by ID which is auto num or by DateEntered which captures date and time record was entered.
PS, I have SQL Express 2005.
I have a table named HistoryChanges with following fields
ID (PK) Int Auto num
Initial varchar (5)
DateEntered DateTime
Other columns are not relevant
Would like to get all records from a given initial which were entered latest.
Meaning if Initial A entered first 5 records then Initial B entered another 5, later Initial A entered 2 records,
If I'm looking for Initial A I would only want see the last two records, while if searching for Initial B I would want see 5 records.
This could be determined either by ID which is auto num or by DateEntered which captures date and time record was entered.
PS, I have SQL Express 2005.
Learn from the best
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 8 Comments.
Try for 7 days”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
Our community of experts have been thoroughly vetted for their expertise and industry experience.