如何在SQL存储过程中使用限制 [英] how to use limit in sql store procedure

问题描述

创建过程订单ID
AS
从order_code中选择order_id ORDER BY order_id DESC LIMIT 1

hai，每个人都在尝试使用limit语句限制表中的数据，但是我遇到了以下错误..我不知道该如何解决..请有人帮助我

以下是iam得到的错误

消息102，级别15，状态1，过程orderid，第3行
靠近"limit"的语法不正确.

CREATE PROCEDURE orderid
AS
SELECT order_id FROM order_code ORDER BY order_id DESC LIMIT 1

hai everyone iam trying to limit the datas from the table using limit statement but i am getting the following error..i dont know how to resolve this ..please someone help me

following is the error iam getting

Msg 102, Level 15, State 1, Procedure orderid, Line 3
Incorrect syntax near ''limit''.

推荐答案

请尝试以下查询.我假设"order_code"是您的表格.

Try below query. I assume "order_code" is your Table.

SELECT Top 1 order_id FROM order_code ORDER BY order_id DESC;

替代方式

SET ROWCOUNT 10
SELECT order_id FROM order_code
SET ROWCOUNT 0 --Reset this again

这篇关于如何在SQL存储过程中使用限制的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！