SQL question

Поиск
Список
Период
Сортировка
Искать
От
kevin kempter
Тема
SQL question
Дата
Msg-id
69712BCF-F10A-4874-BD7D-9A40E1474E19@kevinkempterllc.com
Список
Дерево обсуждения
SQL question kevin kempter <kevin@kevinkempterllc.com>
Re: SQL question "Adam Rich" <adam.r@sbcglobal.net>
Hi List;

I have a table that has 3 date columns :

create table xyz (
xyz_id integer,
date1   timestamp,
date2   timestamp,
date3   timestamp
)


I want to select in a query the xyz_id and the max date column for  
each row
something like :
create table temp2 as select xyz_id (max date?) where ...

Is this - the (max date?) part a case scenario or is there a better,  
more efficient method ?

Thanks in advance

В списке pgsql-general по дате отправления
От: Sushant Sinha
Дата:
От: Adam Rich
Дата:
Сообщение: Re: SQL question
FAQ