select from s_room LIMIT 25 用sqlserver怎么写

SELECT TOP 5 * FROM ( SELECT ROW_NUMBER() OVER (ORDER BY id) AS RowNum, * FROM s_room ) AS s_room_with_rownum WHERE RowNum > 2;

原文地址: http://www.cveoy.top/t/topic/GCT 著作权归作者所有。请勿转载和采集!