Re: get first and last row in one sql as two columns

[Thomas Kellerer <spam_eater@xxxxxxx>]

Tom Smith schrieb am 03.09.2015 um 14:11:
>> 
>>     SELECT first_value(col1) over (order by col1),
>>            last_value(col1)  over (order by col1)
>>     FROM table;
>> 

> The window function works for me (with adding limit 1 in the end to output only one row
> needed instead of many duplicate rows).


If that works for you with a LIMIT 1, then I don't understand why 

   select min(col1), max(col1) 
   from table

doesn't work for you



 



-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general