<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[qq_45967480的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/qq_45967480</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; qq_45967480]]></copyright><item><title><![CDATA[Mysql5.7之开窗函数]]></title><link>https://blog.youkuaiyun.com/qq_45967480/article/details/130124651</link><guid>https://blog.youkuaiyun.com/qq_45967480/article/details/130124651</guid><author>qq_45967480</author><pubDate>Thu, 13 Apr 2023 10:55:43 +0800</pubDate><description><![CDATA[在SQL中我们经常遇到一种需求：分组排序，分组求和等各种需求。像这样的需求，如果在Oracle、SQLserver、postgresql等数据库中很容易实现，一个开窗函数就可以解决。但是在MySQL8.0版本之前，是没有这样的开窗函数的。好在8.0之后的版本已经内置了开窗函数。不必自己写实现逻辑了。但是我们目前还有很多人在使用5.7版本。那么在5.7版本中，如何实现开窗函数的功能呢？]]></description><category></category></item><item><title><![CDATA[RGB颜色对照表]]></title><link>https://blog.youkuaiyun.com/qq_45967480/article/details/126587382</link><guid>https://blog.youkuaiyun.com/qq_45967480/article/details/126587382</guid><author>qq_45967480</author><pubDate>Mon, 29 Aug 2022 16:30:30 +0800</pubDate><description><![CDATA[白色：rgb(255,255,255)青色：rgb(0,255,255)紫色：rgb(255,0,255)红色：rgb(255,0,0)绿色：rgb(0,255,0)蓝色：rgb(0,0,255)黑色：rgb(0,0,0)]]></description><category></category></item><item><title><![CDATA[Oracle中merge into用法解析]]></title><link>https://blog.youkuaiyun.com/qq_45967480/article/details/123048493</link><guid>https://blog.youkuaiyun.com/qq_45967480/article/details/123048493</guid><author>qq_45967480</author><pubDate>Mon, 21 Feb 2022 17:36:30 +0800</pubDate><description><![CDATA[Oracle中merge into用法解析]]></description><category></category></item><item><title><![CDATA[ROW_NUMBER( )取最新一笔数据 用法解析]]></title><link>https://blog.youkuaiyun.com/qq_45967480/article/details/121604635</link><guid>https://blog.youkuaiyun.com/qq_45967480/article/details/121604635</guid><author>qq_45967480</author><pubDate>Thu, 02 Dec 2021 18:40:52 +0800</pubDate><description><![CDATA[Oracle ：row( ) number( )取最新一笔数据]]></description><category></category></item><item><title><![CDATA[generate_series（适用于GP）用法解析]]></title><link>https://blog.youkuaiyun.com/qq_45967480/article/details/121603216</link><guid>https://blog.youkuaiyun.com/qq_45967480/article/details/121603216</guid><author>qq_45967480</author><pubDate>Mon, 29 Nov 2021 10:34:45 +0800</pubDate><description><![CDATA[generate_series（GP）循环函数分享]]></description><category></category></item><item><title><![CDATA[SQL的执行顺序]]></title><link>https://blog.youkuaiyun.com/qq_45967480/article/details/120987192</link><guid>https://blog.youkuaiyun.com/qq_45967480/article/details/120987192</guid><author>qq_45967480</author><pubDate>Mon, 29 Nov 2021 09:46:09 +0800</pubDate><description><![CDATA[SQL执行流程]]></description><category></category></item></channel></rss>