Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Is this possible
"Isaac Blank" <izblank_at_yahoo.com> wrote in message news:<BWuba.837$RT3.94220517_at_newssvr13.news.prodigy.com>...
> SELECT class_id, MIN(doc_num) item_lo,MAX(doc_num) item_hi,
> status
> FROM (
>
> SELECT dt.*, rank() over (Partition By Class_id Order by doc_num) rr
> FROM doctest dt
> )
> GROUP BY class_id,status,rr-doc_num
> ORDER BY class_id,MIN(doc_num)
Yes, that does the trick! Thanks so much Isaac!!!!
-Bill Received on Wed Mar 12 2003 - 10:13:25 CST