Received: from news.tht.net (news.hub.org [216.126.91.242]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f93HYSn56489 for ; Wed, 3 Oct 2001 13:34:29 -0400 (EDT) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.4/8.11.4) id f93HXOL40106 for pgsql-sql@postgresql.org; Wed, 3 Oct 2001 13:33:24 -0400 (EDT) (envelope-from news) From: c.ruffin@ieee.org (Chris Ruffin) X-Newsgroups: comp.databases.postgresql.sql Subject: challenging query Date: 3 Oct 2001 10:33:22 -0700 Organization: http://groups.google.com/ Lines: 26 Message-ID: <579d73bf.0110030933.22b6d76e@posting.google.com> Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Complaints-To: groups-abuse@google.com To: pgsql-sql@postgresql.org X-Archive-Number: 200110/59 X-Sequence-Number: 5014 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?