Hi I basically want to return all of the ticketid's that have a reportdate that was changed
ie...
TICKETID, REPORTDATE
a,17/04/15
a,17/04/15
a,19/02/14
b,12/02/15
b,12/02/15
b,12/02/15
c,01/01/15
c,01/02/15
should return
a,17/04/15
a,19/02/14
c,01/01/15
c,01/02/15
Kinda like the PREVIOUS() function in srss... example was to highlight the...