Return-Path: owner-postman Received: from localhost.Berkeley.EDU (localhost.Berkeley.EDU [127.0.0.1]) by nobozo.CS.Berkeley.EDU (8.6.10/8.6.3) with SMTP id KAA02000 for postgres-redist; Thu, 15 Jun 1995 10:49:59 -0700 Resent-From: POSTGRES mailing list Resent-Message-Id: <199506151749.KAA02000@nobozo.CS.Berkeley.EDU> X-Authentication-Warning: nobozo.CS.Berkeley.EDU: Host localhost.Berkeley.EDU didn't use HELO protocol Sender: owner-postman@postgres.Berkeley.EDU X-Return-Path: owner-postman Received: from twix.cs.UMD.EDU (twix.cs.umd.edu [128.8.126.20]) by nobozo.CS.Berkeley.EDU (8.6.10/8.6.3) with ESMTP id KAA01990 for ; Thu, 15 Jun 1995 10:49:39 -0700 From: sjw@cs.UMD.EDU Received: by twix.cs.UMD.EDU (8.6.11/UMIACS-0.9/04-05-88) id NAA00451; Thu, 15 Jun 1995 13:49:37 -0400 Date: Thu, 15 Jun 1995 13:49:37 -0400 Message-Id: <199506151749.NAA00451@twix.cs.UMD.EDU> To: postgres@postgres.Berkeley.EDU Subject: [Help] About Postquel Resent-To: postgres-redist@postgres.Berkeley.EDU Resent-Date: Thu, 15 Jun 95 10:49:59 -0700 Resent-XMts: smtp I Need to write a qurey to sum one field according another field. For example, I have a table with name, job and salary. I want to get a table with name and salary only. Each name will have only one entry here and the salary will be the summation of all his job. How to write the Postquel ? Is there any good tutorial about POSTQUEL ? Thanks Shuo-jen Wu ============================================================================== To add/remove yourself to/from the POSTGRES mailing list: send mail with the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU". If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and a human will deal with it. DO NOT post to the "postgres" mailing list. ============================================================================== URL: http://s2k-ftp.CS.Berkeley.EDU:8000/postgres/