34,838
社区成员




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;