与MSSQL对比学习MYSQL的心得（七）--查询(4)

USE [sss] GO CREATE TABLE fruits ( f_id CHAR(10) NOT NULL , s_id INT NOT NULL , f_name CHAR(255) NOT NULL , f_price DECIMAL(8, 2) NOT NULL , PRIMARY KEY ( f_id ) ) INSERT INTO fruits ( f_id , s_id , f_name , f_price ) SELECT 'a1' , 101 , 'apple' , 5.2 UNION ALL SELECT 'b1' , 102 , 'blackberry' , 5.2 UNION ALL SELECT 'bs1' , 105 , 'orange' , 5.2 UNION ALL SELECT 'bs2' , 103 , 'melon' , 5.2 UNION ALL SELECT 't1' , 106 , 'banana' , 5.2 UNION ALL SELECT 'a6' , 101 , 'cherry' , 6 UNION ALL SELECT 'a8' , 102 , 'coconut' , 7

先按s_id排序，然后返回第5行开始的3条记录

SELECT * FROM [dbo].[fruits] ORDER BY [s_id] ASC OFFSET 4 ROWS FETCH NEXT 3 ROWS ONLY;