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 по дате отправления