Tu vrei sa grupezi inregistrari dupa '22021CC' - inregistrarea cu = ore=3D47 si '22022BB' - inregistrarea cu ore=3D10 ? Presupun ca aici a fost o greseala de tastare, si ca in ambele cazuri este vorba despre '22021CC'.
Solutia "detaliata" ar fi: claur=3D# select co,co1,n1,l1,m1,sum(ore) as total from xxx group by co,co1,n1,l1,m1; co | co1 | n1 | l1 | m1 | total ---------+------+-----+------+-----+------- 22021CC | 1044 | 637 | S5G8 | 407 | 5 22021CC | 1044 | 637 | S5G8 | 409 | 57 22021CD | 1044 | 637 | S5G8 | 410 | 24 (3 rows) unde: claur=3D# select * from xxx; co | co1 | n1 | l1 | m1 | ore ---------+------+-----+------+-----+----- 22021CC | 1044 | 637 | S5G8 | 407 | 5 22021CC | 1044 | 637 | S5G8 | 409 | 47 22021CD | 1044 | 637 | S5G8 | 410 | 24 22021CC | 1044 | 637 | S5G8 | 409 | 10 (4 rows) -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of cristi Sent: 23 iunie 2004 11:53 To: [EMAIL PROTECTED] Subject: [rlug] SQL (postgres) Am urmatorul tabel a carui structura este: CREATE TABLE "xxx" ( "co" character varying(7), "co1" character varying(9), "n1" character varying(15), "l1" character varying(5), "m1" smallint, "ore" bigint ); si ale caror date continute de acesta sunt: 22021CC 1044 637 S5G8 407 5 22021CC 1044 637 S5G8 409 47 22021CD 1044 637 S5G8 410 24 22022BB 1044 637 S5G8 409 10 Vreau o instructiune sql a carui rezultat sa fie de forma: 22021CC 1044 637 S5G8 407 5 22021CC 1044 637 S5G8 409 57 22021CD 1044 637 S5G8 410 24 Cu alte cuvinte: Sa selecteze numai inregistrarea pt. care co1,n1,l1,m1 este acelasi si are valoarea cea mai mare de ore adaugandu-se la aceasta valoarea orelor de la celelalte care dispar. Va multumesc anticipat! ---=20 Detalii despre listele noastre de mail: http://www.lug.ro/ -------------------------------------------------------------------------= ------ The content of this communication is classified as Mobifon SA Romania = Confidential and Proprietary Information.The content of this = communication is intended solely for the use of the individual or entity = to whom it is addressed and others authorized to receive it. If you are = not the intended recipient you are hereby notified that any disclosure, = copying, distribution or taking any action in reliance on the contents = of this information is strictly prohibited and may be unlawful. If you = have received this communication in error, please notify us immediately = by responding to this communication then delete it from your system. We = appreciate your assistance in preserving the confidentiality of our = correspondence. Thank you. Prezentul mesaj constituie o Informatie confidentiala si este = proprietatea exclusiva a MobiFon S.A.. Mesajul se adreseaza numai = persoanei fizice sau juridice mentionata ca destinatara, precum si altor = persoane autorizate sa-l primeasca. In cazul in care nu sunteti = destinatarul vizat, va aducem la cunostinta ca dezvaluirea, copierea, = distribuirea sau initierea unor actiuni pe baza prezentei informatii = sunt strict interzise si atrag raspunderea civila si penala. Daca ati = primit acest mesaj dintr-o eroare, va rugam sa ne anuntati imediat, ca = raspuns la mesajul de fata, si sa-l stergeti apoi din sistemul dvs. = Apreciem si va multumim pentru sprijinul acordat in pastrarea = confidentialitatii corespondentei noastre.=20 -------------------------------------------------------------------------= ------ --- Detalii despre listele noastre de mail: http://www.lug.ro/
