Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: extracting a sample of each condition
"jobs" <jobs_at_webdos.com> a écrit dans le message de news: 1185415677.091943.26590_at_d55g2000hsg.googlegroups.com...
|
| > Have a look at row_number/rank/dense_rank functions.
| > First_value one may also help.
| >
| > Regards
| > Michel Cadot
|
| I don't know if there is a better way to do this, but I have a working
| solution in the form of:
|
| joining the table to the group by in question. If there is a smarter
| way to do this please let me know.
|
| select s.btn btn,s. plan_code,s. fee_type, s.min_type, s.monthly_fee
| from monthly_fee_samples s join
| (select max(t.btn) btn ,t.plan_code,t.fee_type,t.min_type
| from monthly_fee_samples t group by
| t.plan_code,t.fee_type,t.fee_type,t.min_type) x
| on s.btn = x.btn order by s.plan_code
|
Yes, these raninkg function are made for that. You want the first rows (with rank=1) when you partition by plan_code, fee_type, fee_type, min_type and descending order by btn.
Regards
Michel Cadot
Received on Wed Jul 25 2007 - 23:20:59 CDT