<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[yyfq521的专栏]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/yyfq521</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; yyfq521]]></copyright><item><title><![CDATA[SQL&MySQL 查询添加字段为行号]]></title><link>https://blog.youkuaiyun.com/yyfq521/article/details/41440783</link><guid>https://blog.youkuaiyun.com/yyfq521/article/details/41440783</guid><author>yyfq521</author><pubDate>Mon, 24 Nov 2014 10:16:46 +0800</pubDate><description><![CDATA[SQL：




点击(此处)折叠或打开




select row_number() over(partition
 by name order by col desc) ,* from table;


函数“row_number”必须有使用 ORDER BY 的 OVER 子句,按照字段col来排列自动取值
partition by name order by]]></description><category></category></item></channel></rss>