SQL query
От | pawel@deso.pl (Paul Czubilinski) |
---|---|
Тема | SQL query |
Дата | |
Msg-id | bce5a17a.0402020710.4040123a@posting.google.com обсуждение исходный текст |
Ответы |
Re: SQL query
|
Список | 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
В списке pgsql-sql по дате отправления: