Hi, I have a simple query that should work
select * from dbo.Fund_Price where Date =
(select min(date) from (select * from dbo.Fund_Price where Benchmark_Price is null))
I have no idea why it says Incorrect syntax near ')' where the last ) is. Please help, thanks!