SQL segments in Teradata，

SQL segments in Teradata，

select 
l_returnflag, l_linestatus, sum(l_quantity) as sum_qty,
 sum(l_extendedprice) as sum_base_price, 
sum(l_extendedprice*(1-l_discount)) as sum_disc_price, 
sum(l_extendedprice*(1-l_discount)*(1+l_tax)) as sum_charge,
avg(l_quantity) as avg_qty, 
avg(l_extendedprice) as avg_price, 
avg(l_discount) as avg_disc, 
count(*) as count_order
 from 
database.lineitem 
where 
l_shipdate <= cast('1998-12-01' as date) - cast('5' as interval day) 
group by 
l_returnflag, l_linestatus
 order by 
l_returnflag, l_linestatus; 

 

--用cast实现truncate的功能
select  sum(cast(cast( (cast(cast(((123.4567/2)* 100) as integer) as numeric (9,2)) /100) *2*100 as integer) as numeric(13, 2))/100) from database1.nation group by n_nationkey;