Re: Finding rank adn returning a range around said rank
A very different requirement. Many problems.
SQL is designed for sets rather than for row-to-row computation, which in MySQL is often best done in a general-purpose programming language (PHP, Python, C#, &c).
MySQL does not have SQL Server's CTEs or windowing and ranking functions. At
http://www.artfulsoftware.com/queries.php the articles titled "Emulate Row_Number()" and "Rank order" may be helpful for you if you want a SQL solution.
Subject
Written By
Posted
Re: Finding rank adn returning a range around said rank
July 07, 2016 10:27AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.