16.10 - Usage Example - Teradata Database

Teradata Analytic Functions

prodname
Teradata Database
vrm_release
15.10
16.10
created_date
November 2017
category
Programming Reference
featnum
B035-1206-151K
Input Table: sessionize_table
partition_id clicktime userid productname pagetype referrer productprice
1 1110000 333   Home www.yahoo.com  
1 1112000 333 Ipod Checkout www.yahoo.com 200.2
1 1160000 333 Bose Checkout   340
1 1200000 333   Home www.google.com  
1 1203000 67403   Home www.google.com  
1 1300000 67403   Home www.google.com  
1 1301000 67403   Home    
1 1302000 67403   Home    
1 1340000 67403 Iphone Checkout   650
1 1450000 67403 Bose Checkout   750
1 1450200 80000   Home godaddy.com  
1 1450600 80000 Bose Checkout   340
1 1450800 80000 Itrip Checkout   450
1 1452000 880000 Iphone Checkout   650