date problem

Поиск
Список
Период
Сортировка
От tony
Тема date problem
Дата
Msg-id 1116229689.10597.39.camel@hush
обсуждение исходный текст
Ответы Re: date problem
Re: date problem
Список pgsql-general
Hi,

I thought this would be a classic sort of query but google did no give
me the answer.

I am attempting to select records where one of the dates is the latest
date before today

select max(date) from expo where date < now()

works for one record but other fields I need must be in aggregate or
grouped. Is there a simple SQL request to get the most recent records
from a set of joined tables?

TIA

Tony


В списке pgsql-general по дате отправления: