Hi All,
I am working something tricky here and needed some help.
My DATA looks something like this....
100 500 1
100 500 2
100 500 4
100 500 3
100 500 9
In the above set first two coulmns are the key fields and i need to write a query such that we pull only the record which has minimum value in third field or else if we can go one more step ahead we need to pull records which have least value in the third column.
Is it possible pull this kind of result in teradata?Please help me with this and suggest the best possible way .
Thanks & Regards
I am working something tricky here and needed some help.
My DATA looks something like this....
100 500 1
100 500 2
100 500 4
100 500 3
100 500 9
In the above set first two coulmns are the key fields and i need to write a query such that we pull only the record which has minimum value in third field or else if we can go one more step ahead we need to pull records which have least value in the third column.
Is it possible pull this kind of result in teradata?Please help me with this and suggest the best possible way .
Thanks & Regards