select top 1 * from tablename where date <= '2003-03-10' order by date desc
if not exist( select * from table where date = ???? ) begin select * from table where date in ( select max( date ) from table ) end else select * from table where date = ????
select * from table where date =(select top 1 date from table where date <= '2003-03-10' order by date desc)
select * from table where date =(select top 1 date from table where date <= '2003-03-10' group by date HAVING SUM(shuliang) > 0 order by date desc)
就是这个思路拉select * from table where date =(select top 1 date from table where date <= '2003-03-10' group by date HAVING SUM(shuliang) > 0 order by date desc)
begin
select * from table where date in ( select max( date ) from table )
end
else
select * from table where date = ????