Groups > it.comp.software.database > #2972

Re: [OT] Esperti di query SQL (Oracle)

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	<f1436272-2761-4b3e-9991-fce220c4bfdc@googlegroups.com>
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	<a80ecfaf-2427-4345-a0ef-0cf66728d597@googlegroups.com> <30df0782-a15b-4cc2-bad0-ea04bac9e5ec@googlegroups.com> <f9889a27-6ccf-45fa-a99f-3633f5d69124@googlegroups.com> <1c85da2e-cded-4bb8-9033-8e6d03cb71ac@googlegroups.com> <2ebc4577-4e88-45d0-9ee8-66fe07397466@googlegroups.com> <67b40674-3b22-4f92-9399-8272dd9908f4@googlegroups.com> <f1436272-2761-4b3e-9991-fce220c4bfdc@googlegroups.com>
User-Agent	G2/1.0
MIME-Version	1.0
Message-ID	<4e5fa731-ff48-40b5-8a18-bde174ed50f8@googlegroups.com> (permalink)
Subject	Re: [OT] Esperti di query SQL (Oracle)
From	Giacomo Degli Esposti <giacomo.degliesposti@gmail.com>
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

Show key headers only | View raw

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

Back to it.comp.software.database | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

[OT] Esperti di query SQL (Oracle) Claudio Cioletti <ciole7@gmail.com> - 2015-10-14 01:54 -0700
  Re: [OT] Esperti di query SQL (Oracle) Claudio Cioletti <ciole7@gmail.com> - 2015-10-15 03:07 -0700
  Re: [OT] Esperti di query SQL (Oracle) Giacomo Degli Esposti <giacomo.degliesposti@gmail.com> - 2015-10-15 07:42 -0700
    Re: [OT] Esperti di query SQL (Oracle) Claudio Cioletti <ciole7@gmail.com> - 2015-10-20 08:30 -0700
      Re: [OT] Esperti di query SQL (Oracle) Giacomo Degli Esposti <giacomo.degliesposti@gmail.com> - 2015-10-20 09:13 -0700
        Re: [OT] Esperti di query SQL (Oracle) Claudio Cioletti <ciole7@gmail.com> - 2015-10-21 04:24 -0700
          Re: [OT] Esperti di query SQL (Oracle) Giacomo Degli Esposti <giacomo.degliesposti@gmail.com> - 2015-10-21 06:01 -0700
            Re: [OT] Esperti di query SQL (Oracle) Claudio Cioletti <ciole7@gmail.com> - 2015-10-21 06:42 -0700
              Re: [OT] Esperti di query SQL (Oracle) Giacomo Degli Esposti <giacomo.degliesposti@gmail.com> - 2015-10-21 06:56 -0700
                Re: [OT] Esperti di query SQL (Oracle) Claudio Cioletti <ciole7@gmail.com> - 2015-10-21 07:48 -0700

csiph-web