<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[lllaacc的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/lllaacc</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; lllaacc]]></copyright><item><title><![CDATA[【数据分析第七天】复杂sql语句查询]]></title><link>https://blog.youkuaiyun.com/lllaacc/article/details/135449603</link><guid>https://blog.youkuaiyun.com/lllaacc/article/details/135449603</guid><author>lllaacc</author><pubDate>Wed, 10 Jan 2024 15:51:05 +0800</pubDate><description><![CDATA[窗口函数的位置一般可以放以下2种函数排名函数 rank（）、dense_rank()、row_number()；聚合函数 sum、 avg、percent_rank()；取值函数 first_value()、last_value()、nth_value()、lag()、lead()、ntile()；本文主要研究排名函数因为窗口函数是对where或者group by子句处理后的结果进行操作，所以窗口函数原则上只能写在select子句中。]]></description><category></category></item><item><title><![CDATA[数据分析第四天-简单sql语句查询]]></title><link>https://blog.youkuaiyun.com/lllaacc/article/details/135431122</link><guid>https://blog.youkuaiyun.com/lllaacc/article/details/135431122</guid><author>lllaacc</author><pubDate>Sat, 06 Jan 2024 20:35:13 +0800</pubDate><description><![CDATA[6大主要sql语句]]></description><category></category></item><item><title><![CDATA[第二天excel应用--高效做报表之excel自动填充及函数的混合应用]]></title><link>https://blog.youkuaiyun.com/lllaacc/article/details/135410446</link><guid>https://blog.youkuaiyun.com/lllaacc/article/details/135410446</guid><author>lllaacc</author><pubDate>Fri, 05 Jan 2024 16:55:51 +0800</pubDate><description><![CDATA[高效做报表之excel自动填充及函数的混合应用]]></description><category></category></item><item><title><![CDATA[从0开始学数据分析-第一天excel应用--函数]]></title><link>https://blog.youkuaiyun.com/lllaacc/article/details/135357685</link><guid>https://blog.youkuaiyun.com/lllaacc/article/details/135357685</guid><author>lllaacc</author><pubDate>Fri, 05 Jan 2024 14:54:41 +0800</pubDate><description><![CDATA[excel函数和一些基础功能]]></description><category></category></item></channel></rss>