Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails
SELECT w.idwell, SUBSTR(b.afenumber, INSTR(b.afenumber,'10'),8) network, a.responsiblegrp2 z_eng, a.responsiblegrp1 z_sup, MAX(c.contractor ||' '||c.rigno ) KEEP (DENSE_RANK LAST ORDER BY c.syscreatedate) as RIG , a.syscreatedate, a.wvtyp JOB\ FROM wvwellheader w, wvjob a, wvjobafe b, wvjobrig c WHERE w.idwell = a.idwell AND a.idrec = b.idrecparent AND a.idrec = c.idrecparent AND b.afenumber IS NOT NULL AND c.dttmstart IS NOT NULL AND a.DTTMSTART > to_date( '01/MAY/2008', 'DD/MON/YYYY') AND w.idwell = 'B126D65D02754B0ABAA0394328315D64' GROUP BY a.wvtyp, w.idwell, b.afenumber, a.responsiblegrp2, a.responsiblegrp1, a.syscreatedate
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
17 Experts available now in Live!