T-SQL\u306e\u5c0f\u6280?\u3092\u4e00\u3064\u3002<\/p>\n\n\n\n
MySQL\u3067\u306f\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306bSELECT\u6587\u306bLIMIT\u53e5\u3092\u6307\u5b9a\u3057\u3066\u3001\u30af\u30a8\u30ea\u7d50\u679c\u304b\u3089\u6307\u5b9a\u30aa\u30d5\u30bb\u30c3\u30c8\u304b\u3089\u6307\u5b9a\u4ef6\u6570\u5206\u53d6\u5f97\u3059\u308b\u3053\u3068\u304c\u53ef\u80fd\u3002<\/p>\n\n\n\n
SELECT \u30fb\u30fb\u30fb FROM TABLE_NAME \u30fb\u30fb\u30fb LIMIT 10,5 -- \u30af\u30a8\u30ea\u7d50\u679c\u306e5\u884c\u76ee\u304b\u308910\u884c\u5206\n-- \u307e\u305f\u306f\nSELECT \u30fb\u30fb\u30fb FROM TABLE_NAME \u30fb\u30fb\u30fb LIMIT 10 OFFSET 5 -- \u30af\u30a8\u30ea\u7d50\u679c\u306e5\u884c\u76ee\u304b\u308910\u884c\u5206<\/code><\/pre><\/div>\n\n\n\n\u3067\u306fT-SQL\u3067\u540c\u3058\u4e8b\u3092\u884c\u306a\u3046\u5834\u5408\u306f\u3069\u3046\u3059\u308c\u3070\u826f\u3044\u306e\u304b?<\/p>\n\n\n\n
\u6614\u306f\u30b9\u30de\u30fc\u30c8\u306a\u3084\u308a\u65b9\u306f\u306a\u304b\u3063\u305f\u304c\u3001SQL Server 2012\u304b\u3089\u306f\u4ee5\u4e0b\u306e\u69cb\u6587\u3067\u53d6\u5f97\u304c\u53ef\u80fd\u3068\u306a\u3063\u305f\u3088\u3046\u3060\u3002(\u4f46\u3057\u3001ORDER BY\u53e5\u306e\u4e00\u90e8\u3060\u304c\u30fb\u30fb\u30fb)<\/p>\n\n\n\n
-- \u30af\u30a8\u30ea\u7d50\u679c\u306e@START_OFFSET\u884c\u76ee\u304b\u3089@FETCH_NUMBER\u884c\u5206\u53d6\u5f97\nSELECT COLUMN_1[,COLUMN_2[,...]] FROM TABLE_NAME\n \u30fb\u30fb\u30fb\n ORDER BY KEY_COLUMN\n OFFSET @START_OFFSET ROWS\n FETCH NEXT @FETCH_NUMBER ROWS ONLY<\/code><\/pre><\/div>\n\n\n\n\u203b\u2193EF\u3067SQL Server\u306b\u5bfe\u3057\u3066.Skip\u3084.Take\u3092\u4f7f\u7528\u3059\u308b\u3068\u3001\u4e0a\u8a18\u3068\u540c\u69d8\u306aSQL\u304c\u4f5c\u6210\u3055\u308c\u305f\u3002<\/p>\n\n\n\n
var q = ctx.TABLE_NAME.OrderBy(v=>v.KEY_COLUMN).Skip(n).Take(m);<\/code><\/pre><\/div>\n\n\n\nSELECT \u30fb\u30fb\u30fb\n FROM TABLE_NAME AS [T]\n ORDER BY [T].[KEY_COLUMN]\n OFFSET @__p_0 ROWS FETCH NEXT @__p_1 ROWS ONLY<\/code><\/pre><\/div>\n\n\n\n\u3053\u308c\u3063\u3066\u7d50\u69cb\u4f7f\u3046\u6a5f\u80fd\u3060\u3068\u601d\u3046\u306e\u3060\u3051\u3069\u3001T-SQL\u3067\u30b5\u30dd\u30fc\u30c8\u3055\u308c\u3066\u3044\u305f\u3068\u306f\u77e5\u3089\u306a\u304b\u3063\u305f(^^;<\/p>\n","protected":false},"excerpt":{"rendered":"
T-SQL\u306e\u5c0f\u6280?\u3092\u4e00\u3064\u3002 MySQL\u3067\u306f\u3001\u4ee5\u4e0b\u306e\u3088\u3046\u306bSELECT\u6587\u306bLIMI … \u7d9a\u304d\u3092\u8aad\u3080