好不容易刚把这周熬过去,本以为下周可以浅浅摆一下了,结果又是一堆task带着ddl扑面而来,再加上这几天疫情在身边,出去玩也成了奢望[抓狂]果然,越长大越想活得自在舒坦,遵从内心,但也越不敢松开脚下的油门。也是,生命的车轮不断转动,日子一直在向前,事情又总喜欢扎堆出现,有时候不得不学会接受和放弃,合理调节自己的情绪,珍惜每一个小小的快乐,不至于让自己在埋怨中lose way。
这是我想来想去,最想对自己和身边亲近的人说的话。
这是我想来想去,最想对自己和身边亲近的人说的话。
#数据分析# 一篇非常不错的文章,讲到window functions/analytic functions of SQL,《Why Should I Learn SQL Window Functions?》中文似乎一般翻译成窗口函数/分析函数/开窗函数。
https://t.cn/A6KhMh2J
「The difference between an aggregate function and a window function in SQL is simple. An aggregate function collapses all the rows into a single result, which means you lose access to the individual rows. A window function allows access to each row in the defined window.」
「As you can see, the window function did not group the output into a single output row per currency pair group. Instead, each row now contains additional info: the average closing price for the appropriate currency pair. This can be very useful, as many analyses will require some additional info for each row while still keeping all columns from the initial data set.」
CSDN上也有一篇介绍的文章:
https://t.cn/A6KhMh2i
https://t.cn/A6KhMh2J
「The difference between an aggregate function and a window function in SQL is simple. An aggregate function collapses all the rows into a single result, which means you lose access to the individual rows. A window function allows access to each row in the defined window.」
「As you can see, the window function did not group the output into a single output row per currency pair group. Instead, each row now contains additional info: the average closing price for the appropriate currency pair. This can be very useful, as many analyses will require some additional info for each row while still keeping all columns from the initial data set.」
CSDN上也有一篇介绍的文章:
https://t.cn/A6KhMh2i
11.17 周四 牙疼不是病 疼死来要命 牙龈肿这么高是想疼死谁啊 真是的 早上起来跑去上口语课 考了期中 写了篇作文 chasing star 题目写 chasing your love 写了三段 还不错啦 条例也很清晰 就是没用上啥高级句型 最后一段 in short.rational pursuit of stars don’t lose yourself. Keep your original heart and love bravely. 自认为写的不错 中间段也用到了看老师发的素材 虽然高中也在用 to begin with secondly last but not least on the one land on the other land中午回来化了妆 两点去参加开幕式彩排了 下午两节课 学院给统一请假了 两点去彩排 跳了两遍舞 一遍八段锦 忙到五点四十 跟wxj陈佳去吃了炒菜 牙垠疼死 两遍牙都疼 嚼不了就基本靠咽了 吃完立马又跑去上口语课 加的课 气氛很好 上台演讲了下 energy vehicles 加了分 科来接下课 吃了他买的水果 跟学姐lzy在食堂门口坐了会 送我回来了 拉了臭臭 练了会帕梅拉 给我累挺了 洗了澡洗了内内 大姨妈也准时到来了 明天一节体育课 表演加油
✋热门推荐