select a.CompanyID,b.Price,b.AddTime
from(
select distinct CompanyID from table1 --所有的公司
)a left join table1 b on a.CompanyID=b.CompanyID and DAY(b.AddTime)=DAY(getdate()) and b.AddTime=(
select max(AddTime) as last_time from table1 c where c.CompanyID =b.CompanyID )
select a.CompanyID,b.Price,b.AddTime
from(
select distinct CompanyID from table1 --所有的公司
)a left join table1 b on a.CompanyID=b.CompanyID and b.AddTime=getdate() --当前时间的报价
select * from table1 a , (select CompanyID as C_id, max(AddTime) as last_time from table1 group by CompanyID) b where a.CompanyId = b.C_id and a.AddTime = c.last_time