各种数据库的临时编号的形成（Index）

Mysql

SET @row_number = 0;
SELECT (@row_number := @row_number + 1) AS row_number, column1, column2
FROM table_name;

SQLserver

select * from (
SELECT ROW_NUMBER() OVER (ORDER BY 单号) AS rowno,* FROM(
表名或查询语句
) as a
where 1=1 KaTeX parse error: Expected '}', got 'EOF' at end of input: …no between 20*({page}-1)+1 and 20*${page}