Probably I would get it for supporting the project
Such certificate is unnecessary one
Such certificate is necessary on a site, but not for me
Total Votes: 34956
SQL Exercises news letters, latest issue
As the important news can appear and between releases of news letters, I shall use this page for the publication of the information on all changes on the site.
The forum is not so suitable for this purpose since the message there "escapes" and can appear on previous page before it will lose a urgency.
So look in here if you wish to be well informed about last events on the site. The link to this page is in section of news at the main page below a subscription banner.
New exercise (SELECT) is available now for discussion under the number of 306 (1 point).
Mobile application from Dmitry Ponomarenko is now available for work with site forums. Try this.
Airrule (A17260711) [BK] - Ufa, Rossiya Chatte (A17100984) [BK] - Yaroslavl', Rossiya strannik123 (A17142315) [BK] - Moskva, Rossiya
Number of subscribers - 3233
Number of rating's participants - 12928
Number of second-stage's participants - 2945
Number of third-stage's participants - 118
On the learning stage - 202272
Certified specialists in total - 755
People rather often ask whether there are equivalents for analytic (windowing) functions in MySQL. No, there are not. To replace them, self join queries, complex subqueries, etc, are used. Most of such workarounds turn out to be ineffective.
There are no recursive queries in MySQL either. However, a part of problems usually solved by analytic functions or recursive queries can be handled by features available in MySQL.
One of these features is the unique mechanism of processing variables within a SQL query, which is very unusual for other DBMS. In MySQL, you can declare a variable within a query, change its value, and put it into the result set of the SELECT statement for output. And the most notable thing is, the processing order for query rows, and thus the order values are assigned to variables, can be defined by custom sorting!
Note: this article implies expressions within the SELECT statement are processed in order from left to right; however, there is no confirmation of such a processing order in the official MySQL documentation. You need to keep that in mind when switching from one server version to another. To ensure the required evaluation order, a fake CASE or IF statement can be used.