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
hint This plug-in can only be accessed under the ...
When I first started, I found a lot of errors. In...
This article shares the specific code of JavaScri...
This article is mainly to take you to quickly und...
1. Background Although I have read many blogs or ...
Preface A Docker image consists of a Dockerfile a...
Preface Take Element Plus as an example to config...
nginx is our most commonly used server, often use...
Preface: One day, I built a MySQL service in Dock...
Div basic layout <div class="main"&g...
Table of contents 1. Particle Effects 2. Load the...
Basic concepts of consul Server mode and client m...
This article shares the specific code of React to...
Result:Implementation code: <!DOCTYPE html>...
Count(*) or Count(1) or Count([column]) are perha...