>From my ALCATEL ONE TOUCH T’Pop Gopakumar Pandarikkal <[email protected]> wrote:
>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 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 --- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
