Incorrect syntax near ')'

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!

You have to give alias below a

Select from
( Select statement) a

1 Like