Archives of the TeradataForum
Message Posted: Wed, 02 Jan 2008 @ 14:05:42 GMT
I have a requirement where i have to find the previous adv_num that was been used.
ITEM_NUM ADVC_NUM ITEM_ADVC_EFF_DT 1111 12345 2007/08/29 1111 23456 2007/08/29
In the above table, i need to get the advc_num=23456.How do i get? Cud anyone help me out in solving this issue.I tried using rank function,but i cud nt get it.
Thanks & Regards
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|