select (select max(报价) from yourtable) 历史最高,
(select min(报价) from yourtable) 历史最低,
(select 报价 from yourtable where 时间 =
(select max(时间) from yourtable)) 最新,
(select 报价 from yourtable where 时间 =
(select max(时间) from yourtable where 时间 <>
(select max(时间) from yourtable))) 上一次
(select min(报价) from yourtable) 历史最低,
(select 报价 from yourtable where 时间 =
(select max(时间) from yourtable)) 最新,
(select 报价 from yourtable where 时间 =
(select max(时间) from yourtable where 时间 <>
(select max(时间) from yourtable))) 上一次
select max(报价) 历史最高,
min(报价) 历史最低,
(select 报价 from yourtable where 时间 =
(select max(时间) from yourtable)) 最新,
(select 报价 from yourtable where 时间 =
(select max(时间) from yourtable where 时间 <>
(select max(时间) from yourtable))) 上一次
from yourtable