mysql查询显示行号:SELECT (@rownum := @rownum + 1) AS rownum,U.* FROM USER U,(SELECT @rownum := 0) AS rn
Oracle显示行号:SELECT row_data.*, ROWNUM FROM ( SELECT * FROM jc_gysxx) row_data;
Oracle、mysql显示行号区别
最新推荐文章于 2022-08-31 09:12:52 发布
mysql查询显示行号:SELECT (@rownum := @rownum + 1) AS rownum,U.* FROM USER U,(SELECT @rownum := 0) AS rn
Oracle显示行号:SELECT row_data.*, ROWNUM FROM ( SELECT * FROM jc_gysxx) row_data;