SQL query

From: pawel(at)deso(dot)pl (Paul Czubilinski)
To: pgsql-sql(at)postgresql(dot)org
Subject: SQL query
Date: 2004-02-02 15:10:04
Message-ID: bce5a17a.0402020710.4040123a@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hello,

I would like to retrieve all the records from table A which have given
lang_id and its modification date is later then modification date of
the same id record with lang_id='pl'.

Example:

table A - data example
======================
id | modification_date | lang_id
--------+---------------------+------
abc | 2002-10-11 10:12:11 | en
abc | 2002-11-12 11:12:11 | pl
abc | 2002-11-11 18:12:00 | de
sample | 2003-04-15 22:43:14 | pl
sample | 2003-05-16 11:10:15 | en
sample | 2003-11-11 18:11:10 | de

If given lang_id would be 'en' the following record should be choosed:

sample | 2003-05-16 11:10:15 | en

(it has mofication date later then record with id = sample and lang_id
= pl)

If you have any idea how to make SQL query for this, please help me.

Thanx,
Paul Czubilinski

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Richard Huxton 2004-02-02 15:32:30 Re:
Previous Message Carla Mello 2004-02-02 10:37:03 Re: Executing dynamic queries (EXECUTE)