菜鸟问题，求一个表中（有时间字段）最小时间的那条记录，用SQL怎么写？？

[chinaseven]

菜鸟问题，求一个表中（有时间字段）最小时间的那条记录，用SQL怎么写？？

[yujohny]

select top 1 * from 表 where 时间字段 = (select min(时间字段) from 表)

[happyhsh]

slect * form 表名
where 时间字段 in (selct min 时间字段 from 表名
)

[hjb111]

select * from yourtable where Coltime in (select min(coltime) from t_time)

[hjb111]

不明白你的意思,两种语句你看一看:
select * from yourtable where Coltime in (select min(coltime) from yourtable)
select * from yourtable where Coltime in (select max(coltime) from yourtable)