Received: from resy5.fzk.de (resy5.fzk.de [141.52.68.8]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f95F4bn35796 for ; Fri, 5 Oct 2001 11:04:37 -0400 (EDT) (envelope-from ch@rodos.fzk.de) Received: by rodos.fzk.de with ESMTP (8.8.6 (PHNE_17135)/8.7.1) id RAA11814; Fri, 5 Oct 2001 17:05:41 +0200 (METDST) From: Haller Christoph Message-Id: <200110051503.RAA01444@rodos> Subject: Re: challenging query To: c.ruffin@ieee.org (Chris Ruffin) Date: Fri, 05 Oct 2001 17:03:41 METDST Cc: pgsql-sql@postgresql.org In-Reply-To: <579d73bf.0110030933.22b6d76e@posting.google.com>; from "Chris Ruffin" at Oct 4, 101 7:53 pm X-Mailer: Elm [revision: 212.4] X-Archive-Number: 200110/87 X-Sequence-Number: 5042 > > Consider the following table: > > A B C D select? > ------------------------------- > 1 FOO A1 100 n > 1 BAR Z2 100 n > 2 FOO A1 101 y > 2 BAR Z2 101 y > 3 FOO A1 102 y > 4 BAR Z2 99 y > 5 FOO A1 99 n > 6 BAR Z2 98 n > 7 FOO AB 103 y > 7 BAR ZY 103 y > > This table has the idea of "groups", that is, a group is defined as > all of the words from B that have the same number A. The values in > column C also matter- we want to select both groups A=7 and A=1 since > they contain different values C. Note that the groups defined by A=1 > and A=3 are distinct- they do not contain the same number of words > from B, so we want to select them both. Also note that D is datetime, > and all the rows with the same number A will have the same D (this is > actually ensured by a single row in another table.) > > I want to select all of the numbers A which define distinct groups and > have the highest datetime D. Is this possible in a SQL query? > Now that I've read your request more attentively, I understand what you want. But I have to admit I have no idea how to word the query, I even don't know if it's possible at all. Regards, Christoph