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" <icestor...@hotmail.com> 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 <kkumar.sandee...@gmail.com> wrote: > you can use PL SQL cursor al... > On 1/7/11, Michael Moore <michaeljmo...@gmail.com> wrote: > > > > > > > PS, > > this does not cove... > > <michaeljmo...@gmail.com>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 <icestor...@hotmail.com> 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 Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en
