| To: | REALbasic NUG Italian <realbasic-nug.it@lists.realsoftware.com> |
|---|---|
| Subject: | Re: query SQL |
| From: | Gualeni Giovanni <ggualeni@tiscali.it> |
| Date: | Mon, 8 Jun 2009 10:07:24 +0200 |
| Authentication-results: | mx.google.com; spf=neutral (google.com: 74.124.194.228 is neither permitted nor denied by best guess record for domain of realbasic-nug.it-bounces@lists.realsoftware.com) smtp.mail=realbasic-nug.it-bounces@lists.realsoftware.com |
| Delivered-to: | listarchive@realsoftware.com |
| In-reply-to: | <9FF3E7E1-7D1A-4EEC-94D7-1C210B6021A8@tiscali.it> |
| References: | <9FF3E7E1-7D1A-4EEC-94D7-1C210B6021A8@tiscali.it> |
| Reply-to: | REALbasic NUG Italian <realbasic-nug.it@lists.realsoftware.com> |
| Sender: | realbasic-nug.it-bounces@lists.realsoftware.com |
Il giorno 08/giu/09, alle ore 09:56, Gualeni Giovanni ha scritto: Buon inizio di settimana a tutti, ho la seguente tabella (la parte importante diciamo) NUMBER LAP PENT 10 1 12 42 1 1 52 1 18 42 2 12 86 1 11 42 3 2 SELECT PETT, SUM(PENT) AS PN FROM TAB GROUP BY PETT ORDER BY PNQuesto mi da la somma per PETT ma come dovrebbe essere la query per poter estrarre la somma di PENT per ogni NUMBER ma suddivisa per LAP ? (mi sto montizzando)Giovanni Scusate, PETT e NUMBER sono la stessa cosa: SELECT NUMBER, SUM(PENT) AS PN FROM TAB GROUP BY NUMBER ORDER BY PN Giovanni |
| <Prev in Thread] | Current Thread | [Next in Thread> |
|---|---|---|
| ||
| Previous by Date: | query SQL, Gualeni Giovanni |
|---|---|
| Next by Date: | Re: query SQL, Gualeni Giovanni |
| Previous by Thread: | query SQL, Gualeni Giovanni |
| Next by Thread: | Re: query SQL, Gualeni Giovanni |
| Indexes: | [Date] [Thread] [Top] [All Lists] |