- cast() 函数的使用 将某种数据类型显式转换成另一种数据类型
-
cast('12' as integer)
select cast((year(current_date)-year(birth)) as integer) as age, sum(price) as totalPrice from record r join user_dimension u on r.uid = u.uid group by cast((year(current_date)-year(birth)) as integer) order by totalPrice desc;
转载于:https://my.oschina.net/zdtdtel/blog/1822678