|
Hey you guys!
Assume the following data set:
Student Campus
A School_1
A Alt_site
A School_1
B School_1
B Alt_site
B School_2
Assume schools are sorted in the order in which they were attended.
How do I get a list of just the sending schools (schools immediately
before the Alt_site)? In other words, how do I get 2 School_1's as the
sending schools.
TIA,
-phil
|