-- 创建临时表
CREATE TEMPORARY TABLE temp1 AS ( SELECT (@rowindex := @rowindex +1) AS rowindex,a.city_id,b.name as 'city_name' ,a.dept_name,a.final_point
FROM aqjd_assessment_dept a
JOIN sys_city b on a.city_id = b.id
JOIN (SELECT (@rowindex := 0)) c -- rowindex 初始化
WHERE a.city_station =1
ORDER BY a.final_point DESC
);
- ROW_NUMBER sqlserver NUMBER mysql indexrow_number sqlserver number mysql row_number number mysql row row_number rank dense_rank row_number函数 column row_number partition column1 dense_rank dense rank row_number row_number number rownum row row_number row server number row_number number row row_number postgresql函数amp