おすすめレシピ
SQLSTATE[HY000]: General error: 20018 Invalid usage of the option NEXT in the FETCH statement. [20018] (severity 15) [SELECT
*,
CASE
WHEN create_date > dateadd(day,-90,getdate()) THEN 'new'
ELSE ''
END AS new_tag
FROM kgm_recipe
WHERE recipe_division = 1 AND recipe_revision = 0 AND ( using_products LIKE '%5656%')
ORDER BY update_date DESC,create_date DESC,recipe_code
OFFSET -20 FETCH NEXT 20 ROWS ONLY]