0 - 3 of 3 tags for rank over

I have a table which I have created using group by grouping sets. It is done on 7 columns and at various levels.
Now at each level, i need to rank the lower hierarchical level using rank over function.
Can anyone help me with the syntax of the code?


Hi.  Hoping you can help me with another issue.  I have some data similar to that shown below, and would like to rank the states - 1-50 based on their sales totals.


cust,state,sls,State_Sls_total,desired results,observed results



c ,MN,3,6,2,5



Hi am new to Teradata and am stuck with a problem


There is an ID table which stores an Unique ID given to each person