找出每只基金中第一个小于等于date的净值,如果不存在则不返回该基金
SELECT Max([CurrDate])
,[Code]
FROM [Fund123].[dbo].[NetValues]
where CurrDate <= '2003-12-18 00:00:00.000' and isdeleted=0
Group by Code
GO
找出每只基金中第一个小于等于date的净值,如果不存在则不返回该基金
SELECT Max([CurrDate])
,[Code]
FROM [Fund123].[dbo].[NetValues]
where CurrDate <= '2003-12-18 00:00:00.000' and isdeleted=0
Group by Code
GO