On Wed, Sep 02, 2015 at 07:14:40PM -0400, Tom Smith wrote: > Hi: > > I need to get the first and last tow in one sql like below > > select first(col1), last(col1) from table order by col1
Have you tried the window functions [1] last_value and first_value?
You could use something like:
SELECT first_value(col1) over (order by col1), last_value(col1) over (order by col1) FROM table;
It should be as simple as that, or I miss your point.