Monthly Archives: January 2017
在Mysql中模拟ROW_NUMBER, RANK, DENSE_RANK
从MariaDB 10.2.0版本，开始支持window类函数，但现在还不是正式版本，不建议在生产环境使用。 可以使用下面的sql语句，模拟ROW_NUMBER, RANK, DENSE_RANK函数的功能。这种写法不需要做表的自连接，性能会比较好。
Xing AiMing's Home Page – 邢爱明的个人网站
My notes about Oracle management and ABAP/Java web development.
Recent Posts
RSS
Feed订阅Tags
Archives
- November 2019 (1)
- May 2019 (1)
- January 2019 (1)
- November 2018 (1)
- July 2018 (1)
- April 2018 (5)
- December 2017 (1)
- November 2017 (1)
- August 2017 (1)
- April 2017 (1)
- March 2017 (2)
- February 2017 (1)
- January 2017 (1)
- November 2016 (1)
- July 2016 (2)
- June 2016 (2)
- April 2016 (5)
- March 2016 (1)
- February 2016 (1)
- January 2016 (6)
- December 2015 (3)
- November 2015 (4)
- October 2015 (1)
- August 2015 (1)
- January 2015 (3)
- December 2014 (1)
- November 2014 (3)
- June 2014 (1)
- March 2014 (1)
- February 2014 (2)
- January 2014 (1)
- December 2013 (1)
- November 2013 (4)
- September 2013 (2)
- August 2013 (4)
- June 2013 (8)
- May 2013 (13)
- April 2013 (2)
- March 2013 (1)
- February 2013 (4)
- January 2013 (6)
- December 2012 (3)
- November 2012 (4)
- October 2012 (2)
- September 2012 (1)
- August 2012 (5)
- May 2012 (5)
- April 2012 (1)
- March 2012 (1)
- February 2012 (4)
- January 2012 (5)
- December 2011 (6)
- November 2011 (5)
- October 2011 (1)
- September 2011 (8)
- August 2011 (7)
- July 2011 (1)
- June 2011 (19)
- May 2011 (22)
- April 2011 (6)
- March 2011 (10)
- February 2011 (13)
- January 2011 (16)
- December 2010 (6)
- October 2010 (3)
- September 2010 (4)
- June 2010 (6)
- May 2010 (2)
- April 2010 (5)
- January 2010 (2)
- December 2009 (11)
- November 2009 (5)
- October 2009 (2)
- August 2009 (5)
- July 2009 (1)
- May 2009 (3)
- April 2009 (1)
- March 2009 (1)
- January 2009 (1)
- December 2008 (6)
- October 2008 (7)
- September 2008 (8)
- August 2008 (3)
- April 2008 (2)
- March 2008 (6)
- February 2008 (7)
- January 2008 (5)
- December 2007 (1)
- November 2007 (4)
- October 2007 (6)
- September 2007 (13)
- August 2007 (4)
- July 2007 (9)
- May 2007 (3)
- April 2007 (3)
- March 2007 (4)
- January 2007 (4)
- December 2006 (2)
- November 2006 (1)
- September 2006 (6)
- August 2006 (1)
- June 2006 (2)
- May 2006 (2)
- February 2006 (1)
- January 2006 (1)
- December 2005 (1)
- November 2005 (4)
- October 2005 (1)
- September 2005 (10)