how about this? first normal mins are found out,then they arep minused from the main table again second mins are found out. first and second unioned. no gurantee aboit performance. still you may give it a try.
with q1 as( select id,min(dt) dt from tab group by id,dt), q2 as ( select id,dt from tab minus select id,dt from q1) , q3 as(select id,min(dt) dt from q2) select id,dt from q1 union select id,dt from q3 regards Gopa On Jan 7, 2011 11:51 PM, "crocboy25" <[email protected]> wrote: I can't use PL SQL for this task. It is for a user to use from time to time and the person is not tech savy. I am trying to dumb it down. On Jan 7, 4:56 am, sandeep kumar <[email protected]> wrote: > you can use PL SQL cursor al... > On 1/7/11, Michael Moore <[email protected]> wrote: > > > > > > > PS, > > this does not cove... > > <[email protected]>wrote: > > >> This should tell you what you need to do. > > >> SELECT * > >> FROM (SELECT do.customer_id,... > >> On Thu, Jan 6, 2011 at 12:42 PM, crocboy25 <[email protected]> wrote: > > >>> Hello Group,... > >>> persons.certified_burner_num,persons.last_name,open_burn_requests.request_date, > >>> open_burn_requests.certified_burn_flag, > >>> open_burn_requests.acres > >>> ... > >>> (19870006,19870013,19870024,19870029,19870030,19870033,19870093,19870118,19870125,19870158,19870166,19870170,19870225,19870250) > >>> order by 3) > >>> WHERE ROWNUM<=2; > > >>> Any help would be great appreciated. > >... > --http://www.google.com/profiles/kkumar.sandeep89- Hide quoted text - > > - Show quoted text - -- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To ... -- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en
