 |
 |
Archives of the TeradataForum
Message Posted: Thu, 11 Aug 2005 @ 10:52:24 GMT
| Subj: | | Re: Help need on Tricky SQL |
| |
| From: | | Victor Sokovin |
| | I thought the analytical functions might help me, something like | |
> select key ,MIN(applied) OVER (PARTITION BY Key ORDER BY applied),
> MAX(applied) OVER (PARTITION BY Key ORDER BY applied)
Just get rid of the ORDER BY in the above. You don't need this extra ordering because MIN and MAX are doing the ordering for you. I think this
is the only problem with your SQL. Please get back if it still does not work.
Regards,
Victor
| |
