extracting a sample of each condition

Hello.

Say i have a table that looks like this:

name date plan type1 type2 type3 amount

it's unique by name

I'd like the first record of every of every combination of

plan type1 type2 type3

Can somebody help with the SQL for that?

Thanks for any help or information. Received on Tue Jul 24 2007 - 20:53:15 CDT