Hi Steve,
Steve Kiehl wrote:
I was a bit stumped on a good method to select the second record for
each distinct group in a table. Say I have a table like the following:
NAME
DATE
AMOUNT
joe 2007-10-03 19:44:57 45
joe 2007-10-06 19:46:18 90
joe 2007-10-07 19:37:21
I was a bit stumped on a good method to select the second record for
each distinct group in a table. Say I have a table like the following:
NAME
DATE
AMOUNT
joe 2007-10-03 19:44:57 45
joe 2007-10-06 19:46:18 90
joe 2007-10-07 19:37:21 12
matt2007-10-0
