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

a,MN,1,6,2,5

b,MN,2,6,2,5

c ,MN,3,6,2,5

d,WI,1,10,1,1

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