Search results
-
G
Select based on first item for each group.
Wonderful ideas!! I'm an old (OLD!) mainframe SQL programmer and forgot about saving items from record to record. I'll try those approaches. Thank you all! -
G
Select based on first item for each group.
What I'm trying to do is so simple but I'm missing something. I want to get a report to track patient's pain level and list when it's increasing. I want rows where pain level is greater than the first observation. The table: PatID Date Pain 1 01/1/01 6 1 02/1/01 4 1...