Shulou(Shulou.com)05/31 Report--

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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.