这题有一个难点,要筛选某一个日期的前一天的数据。经调试出来了,假设这张基金净值表叫做fund,只用一句话就可以实现楼主想要的功能:假设是要查询7月1号到8月1号每只基金的增长率:select r.基金代码,(r.复权净值-t.复权净值)/t.复权净值 as 基金增长率 from(select * from (select a.基金代码 as temp_fund,max(a.净值日期) as tem...
首先你所给的例子不是宾语从句,而是由before 引导的时间状语从句,宾语从句必须用陈述句语序,而主句没有限制。 can you tell me where you used to live before you came here? he didn't tell me where you used to live, before you came here?