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

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