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