34,593
社区成员
发帖
与我相关
我的任务
分享
SELECT *
FROM Table1 AS a
CROSS APPLY ( SELECT TOP 1
*
FROM 表名
WHERE a.列 >= startV
AND a.列 <= endV
ORDER BY startV
) AS b;
[/quote]
非常感谢,终于解决了我的问题SELECT *
FROM Table1 AS a
CROSS APPLY ( SELECT TOP 1
*
FROM 表名
WHERE a.列 >= startV
AND a.列 <= endV
ORDER BY startV
) AS b;