SQL segments in Teradata

最新推荐文章于 2024-07-21 16:04:19 发布

原创最新推荐文章于 2024-07-21 16:04:19 发布 · 550 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#teradata #sql #integer #database #date

数据库开发同时被 2 个专栏收录

93 篇文章

订阅专栏

Teradata相关

7 篇文章

订阅专栏

本文提供了两个SQL查询案例，第一个案例展示了如何使用SQL从lineitem表中筛选数据并进行聚合操作；第二个案例则演示了如何利用cast函数实现数值截断。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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;