Re: extracting a sample of each condition

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Wed, 25 Jul 2007 06:06:46 +0200
Message-ID: <46a6cc56$0$9027$426a74cc@news.free.fr>

"jobs" <jobs_at_webdos.com> a écrit dans le message de news: 1185328395.235116.113380_at_w3g2000hsg.googlegroups.com...
| 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.
|

Have a look at row_number/rank/dense_rank functions. First_value one may also help.

Regards
Michel Cadot Received on Tue Jul 24 2007 - 23:06:46 CDT