![](https://img-blog.csdnimg.cn/20201014180756918.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
sql
Girl or girl
路漫漫其修远兮
展开
-
Teradata关键字
CREATE MULTISET TABLE bilibili ,NO FALLBACK ,NO BEFORE JOURNAL,NO AFTER JOURNAL,CHECKSUM = DEFAULT,DEFAULT MERGEBLOCKRATIO(Emp_Id VARCHAR(20) CHARACTER SET LATIN NOT CASESPECIFIC TITLE ‘员工代码’ NOT NULL)1 CHECKSUM = DEFAULTCHECKSUM 是用来校验数据是否损坏的。DEFA原创 2021-10-19 14:12:11 · 444 阅读 · 0 评论 -
2021-09-04
ran() over (order by ) ,dense_rank() over(order by ) ,qualify row_number()over(partition by columns1,columns2,3,4 order by columns desc,columns DESC)=1ran() over (order by ) :间断排序 例如:1,2,3,5,6,7dense_rank() over(order by ):连续排序 例如::1,2,2,3qualify原创 2021-09-04 10:57:48 · 129 阅读 · 0 评论 -
2021-08-28
求多列的最大值,greatest 函数原创 2021-08-28 23:48:30 · 61 阅读 · 0 评论