sql 语句

[Juedaifanghua]

从某张表里取一条数据 条件是它的创建时间最早 条件怎么写

[xumeng929]

select * from table where createtime=(select min(createtime) from table)

[真的不知道取什么名]

select * 
from tb t1
where not exists(select 1 from tb t2 where t1.ctime>t2.ctime)

[hanks_gao]

select * from table 
where createtime=(
    select min(createtime) 
    from table where colName = 'colValue'
) and colName = 'colValue'

[加油馒头]

得出最小时间即可

[lixinbill]

select * from table where createtime=(select min(createtime) from table)

[苹果城的肥瓜]

select *
from tb t1
where not exists(select 1 from tb t2 where t1.ctime>t2.ctime)

[wubing1111]

[Quote=引用 1 楼 xumeng929 的回复:]
select * from table where createtime=(select min(createtime) from table)
[/Quote]
楼上的正确的

[搭火箭看日出]

也是这么想的

[crmcrm4]

select * from table_name where createtime in (select min(createtime) from table_name)

[yejihui9527]

createtime 有吗
select * from table_name where rowid = (select min(rowid) from table_name)
rowid 不知道行不行

[yinan9]

[Quote=引用 3 楼 hanks_gao 的回复:]
SQL code

select * from table
where createtime=(
select min(createtime)
from table where colName = 'colValue'
) and colName = 'colValue'
[/Quote]对了