At Percona’s web store you can order your MongoDB database support needs in minutes. No hassles, no fuss, just pick and click. Pay online with a credit card. Handle your MongoDB database support now!
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
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.