accessing the first row in a table

Database

accessing the first row in a table

Hi, 

I am new to teradata and I have to convert SAS code to teradata. The SAS code goes like this 

if first.CRD_ACCT_NBR then do ;

nbsup=0; end;
if PRIM_CRD_IND = 'S' then nbsup=sum(nbsup,1,0);
retain nbsup;
if last.CRD_ACCT_NBR then output ;
run ;

I need to set value for nbsup as 0 when i have the first instance of CRD_ACC_NBR. 

Please help me to convert this into teradata SQL. 

 

 

Thanks 

 

1 REPLY
Teradata Employee

Re: accessing the first row in a table

From what little I know of SAS language, the SQL equivalent (in any database, not just Teradata) would be:

 

select count(*) from <table-name> group by CRD_ACCT_NBR where PRIM_CRD_IND = 'S'