pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: c.ruffin@ieee.org
To: pgsql-sql@postgresql.org
Subject: challenging query
Date: 3 Oct 2001 10:33:22 -0700
Message-ID: <579d73bf.0110030933.22b6d76e@posting.google.com> (raw)

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?



view thread (5+ messages)  latest in thread

Message-ID: <579d73bf.0110030933.22b6d76e@posting.google.com>
Permalink:  ../579d73bf.0110030933.22b6d76e@posting.google.com/
Also on:    postgresql.org/message-id/579d73bf.0110030933.22b6d76e@posting.google.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: c.ruffin@ieee.org
  Subject: Re: challenging query
  In-Reply-To: <579d73bf.0110030933.22b6d76e@posting.google.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox