slect * form 表名 where 时间字段 in (selct min 时间字段 from 表名 )
select * from yourtable where Coltime in (select min(coltime) from t_time)
不明白你的意思,两种语句你看一看: select * from yourtable where Coltime in (select min(coltime) from yourtable) select * from yourtable where Coltime in (select max(coltime) from yourtable)
where 时间字段 in (selct min 时间字段 from 表名
)
select * from yourtable where Coltime in (select min(coltime) from yourtable)
select * from yourtable where Coltime in (select max(coltime) from yourtable)