Does Mysql support ordinal operations directly?
The main content of this article is to explain "does Mysql directly support sequential operations?", interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Next, let the editor take you to learn "does Mysql directly support sequential operations?"
MySQL does not directly support ordinal operations, so it is troublesome to write these, something like this:
Select t.*
From
(select t1.*
(select count (*) + 1
From A
Where g=t1.g
And x > t1.x
) as group_id
From A t1
) t
Where group_id
