X-Received: by 10.182.28.100 with SMTP id a4mr7852139obh.20.1445435793402; Wed, 21 Oct 2015 06:56:33 -0700 (PDT) X-Received: by 10.182.56.230 with SMTP id d6mr132682obq.9.1445435793371; Wed, 21 Oct 2015 06:56:33 -0700 (PDT) Path: csiph.com!optima2.xanadu-bbs.net!xanadu-bbs.net!news.glorb.com!kq10no24694937igb.0!news-out.google.com!z4ni27647ign.0!nntp.google.com!kq10no20726973igb.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail Newsgroups: it.comp.software.database Date: Wed, 21 Oct 2015 06:56:33 -0700 (PDT) In-Reply-To: Complaints-To: groups-abuse@google.com Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=2.228.162.170; posting-account=jDcyvgoAAAANyVzgTtAUn_1VPqnPtnw1 NNTP-Posting-Host: 2.228.162.170 References: <30df0782-a15b-4cc2-bad0-ea04bac9e5ec@googlegroups.com> <1c85da2e-cded-4bb8-9033-8e6d03cb71ac@googlegroups.com> <2ebc4577-4e88-45d0-9ee8-66fe07397466@googlegroups.com> <67b40674-3b22-4f92-9399-8272dd9908f4@googlegroups.com> User-Agent: G2/1.0 MIME-Version: 1.0 Message-ID: <4e5fa731-ff48-40b5-8a18-bde174ed50f8@googlegroups.com> Subject: Re: [OT] Esperti di query SQL (Oracle) From: Giacomo Degli Esposti Injection-Date: Wed, 21 Oct 2015 13:56:33 +0000 Content-Type: text/plain; charset=ISO-8859-1 Xref: csiph.com it.comp.software.database:2972 On Wednesday, October 21, 2015 at 3:42:35 PM UTC+2, Claudio Cioletti wrote: > Quasi! > Anche utilizzando la ROWID, i tuoi dati non sono corretti: [...] > SERVICE_01 25/06/2015 11:21:57 26/06/2015 12:29:13 > SERVICE_01 26/06/2015 10:53:59 26/06/2015 16:25:18 [...] > mentre i dati corretti sono: [...] > SERVICE_01 25/06/2015 11:21:57 26/06/2015 16:25:18 [...] OK, adesso finalmente ho capito cosa volevi ottenere e perche' ti esce una query cosi' complessa. In pratica da quello che vedo hai bisogno di riunire piu' record "incatenati tra loro" in un solo record. Allora si, la mia query non puo' andare perche restituisce solo record presenti nella tabella originaria. A sto punto, se hai trovato la soluzione buon per te! :) ciao Giacomo