Hi friends.
I have an interbal table and I wnt to read the first and the last recod from the table based on the entries.
for eg.
TRFGB ENDDA BEGDA
4A 20040131 20030201
4A 20050131 20040201
4A 20050504 20050201
4A 99991231 20050505
ZB 20020131 20011231
ZB 20020615 20020201
ZB 20030131 20020616
Now my output should be..
TRFGB ENDDA BEGDA
4A 99991231 20030201
ZB 20030131 20011231
I cant use 2nd table.
Please help me with a code.....
thanxx in advance