UC知道sql怎么取中间的
来源：百度知道 编辑：UC知道 时间：2024/05/23 11:39:39
sql="select top 3 P_Id,P_Name,P_Pic,P_Memo from Product where P_Language='"&lan&"' order by P_Special desc,P_Order,P_Id desc"
我想取从4到6，，怎么改，，用了多种方法不行，谢谢
sql="select top 3 P_Id,P_Name,P_Pic,P_Memo from Product where P_Id in(select top 3 P_Id from Product order by P_Id desc,P_Special desc, P_Order desc) and P_Language='"&lan&"'" 问题解决
我想取从4到6，，怎么改，，用了多种方法不行，谢谢
sql="select top 3 P_Id,P_Name,P_Pic,P_Memo from Product where P_Id in(select top 3 P_Id from Product order by P_Id desc,P_Special desc, P_Order desc) and P_Language='"&lan&"'" 问题解决
select top 3 P_Id,P_Name,P_Pic,P_Memo from Product
where P_Id in(select top 4 P_Id from Product order by P_Id desc,P_Special desc, P_Order desc)and P_Language='"&lan&"'
就可以了,用着好就给点分啊
1楼的可以