Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Analytics or not

Analytics or not

From: Martic Zoran <zoran_martic_at_yahoo.com>
Date: Fri, 8 Apr 2005 09:02:14 -0700 (PDT)
Message-ID: <20050408160214.59743.qmail@web52609.mail.yahoo.com>

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
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Apr 08 2005 - 12:12:17 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US