22,209
社区成员
发帖
与我相关
我的任务
分享
SELECT 序号= (SELECT COUNT(合同号) FROM 订单 AS LiMing WHERE LiMing.合同号<= Chang.合同号) FROM 订单 AS Chang where 合同号='009' ORDER BY 1
SELECT 序号=
(SELECT COUNT(合同号) FROM 订单 WHERE 合同号<= Chang.合同号)
FROM 订单 AS Chang where 合同号='009' ORDER BY 1
SELECT 序号= (SELECT COUNT(合同号) FROM 订单 AS LiMing WHERE LiMing.合同号<= Chang.合同号 and LiMing.合同号='009')
FROM 订单 AS Chang where 合同号='009' ORDER BY 1
SELECT 序号= (SELECT COUNT(合同号) FROM 订单 AS LiMing WHERE LiMing.合同号<= Chang.合同号 where LiMing.合同号='009')
FROM 订单 AS Chang where 合同号='009' ORDER BY 1
--SELECT COUNT(合同号) FROM 订单 AS LiMing WHERE LiMing.合同号<= Chang.合同号
查询小于或等于'009'的合同号记录行!