Analytics or not
- From: Martic Zoran <zoran_martic@xxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 8 Apr 2005 09:02:14 -0700 (PDT)
You have the result set from some SQL.
You want to return up to 1000 rows but broken down to
the last partition in the set partitioned by a few
logical columns (like employee id, ...).
How to do this?
e.g
you have
1
2
2
3
3
3
4
4
4
5
5
5
5
but you want back:
1
2
2
3
3
3
4
4
4
because 5's are the new partition that will not fit in
10 you want to return back.
Now just replace numbers with the many columns.
Regards,
Zoran
__________________________________
Yahoo! Messenger
Show us what our next emoticon should look like. Join the fun.
http://www.advision.webevents.yahoo.com/emoticontest
--
//www.freelists.org/webpage/oracle-l
Other related posts:
