Syntax: Example: Analysis: Can also be used like this:
Create a test table and insert test data CREATE TABLE TEST_ROW_NUMBER_01( CMZH varchar(10) not null, CYLH varchar(10) null, MJE money null, ); INSERT INTO TEST_ROW_NUMBER_01(CMZH,CYLH,MJE) VALUES (2106000011,20281997,10.50) INSERT INTO TEST_ROW_NUMBER_01(CMZH,CYLH,MJE) VALUES(2106000010,20281996,10.50) INSERT INTO TEST_ROW_NUMBER_01(CMZH,CYLH,MJE) VALUES(2106000008,20281995,0.00) INSERT INTO TEST_ROW_NUMBER_01(CMZH,CYLH,MJE) VALUES(2106000006,20281994,9.50) INSERT INTO TEST_ROW_NUMBER_01(CMZH,CYLH,MJE) VALUES(2106000004,20281993,5.50) INSERT INTO TEST_ROW_NUMBER_01(CMZH,CYLH,MJE) VALUES(2106000001,20281992,10.50) INSERT INTO TEST_ROW_NUMBER_01(CMZH,CYLH,MJE) VALUES(2106000002,20281992,10.50) INSERT INTO TEST_ROW_NUMBER_01(CMZH,CYLH,MJE) VALUES(2106000007,20217280,0.00) INSERT INTO TEST_ROW_NUMBER_01(CMZH,CYLH,MJE) VALUES(2106000009,20172458,5.50) INSERT INTO TEST_ROW_NUMBER_01(CMZH,CYLH,MJE) VALUES(2106000005,20121813,0.00) Execute the script to automatically generate line numbers and sort by CYLH (swipe to view the code) SELECT ROW_NUMBER() OVER(ORDER BY CYLH DESC) AS ROWNUM,* FROM TEST_ROW_NUMBER_01 The results are as follows: Note: When using window functions such as This is the end of this article about using SQL ROW_NUMBER() OVER function to generate serial numbers. For more information about using SQL ROW_NUMBER() OVER to generate serial numbers, please search 123WORDPRESS.COM's previous articles or continue to browse the following related articles. I hope everyone will support 123WORDPRESS.COM in the future! You may also be interested in:
|
<<: What are the attributes of the JSscript tag
>>: Introduction and use of five controllers in K8S
Create a table CREATE TABLE `map` ( `id` int(11) ...
Table of contents vue2.x Pre-concept: Routing hoo...
This article shares the specific code of js to im...
Preface In the early stages of some projects, dev...
Table of contents 1. Scene layout 2. Add a handle...
1. When inserting, updating, or removing DOM elem...
This article uses Vue to simply implement the cha...
Table of contents 1. Declare a function 2. Callin...
MySQL is a relational database management system ...
This article example shares the specific code of ...
When I wrote the Redis book and the Spring Cloud ...
What is bond NIC bond is a technology that is com...
If you're collecting information from your us...
CSS has two pseudo-classes that are not commonly ...
This article shares the specific code of JavaScri...