Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to query teradata based on ranking(Ranking also should be done by

Status
Not open for further replies.

shrik2leo

Programmer
Mar 3, 2012
1
US
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top