sql 语句 从某张表里取一条数据 条件是它的创建时间最早 条件怎么写 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select * from table where createtime=(select min(createtime) from table) select * from tb t1where not exists(select 1 from tb t2 where t1.ctime>t2.ctime) select * from table where createtime=( select min(createtime) from table where colName = 'colValue') and colName = 'colValue' select * from table where createtime=(select min(createtime) from table) select * from tb t1where not exists(select 1 from tb t2 where t1.ctime>t2.ctime) select * from table_name where createtime in (select min(createtime) from table_name) createtime 有吗select * from table_name where rowid = (select min(rowid) from table_name)rowid 不知道行不行 job等待 Oracle 9i 安装!急用........... 奇怪的问题,在线等,急!!! case语句在不同机器上结果不同 oracle导入数据存放问题! 日期比较问题。 表空间中无权限是怎么回事? 第一次用oracle,大家请帮忙 大哥救命呀,一天了 在oracle9i的客户端,开始-〉运行下,输入sqlplus,出现协议适配器错误,为什么? 建视图,求助 oracle sql developer 要如何才能使用调试功能呢?
from tb t1
where not exists(select 1 from tb t2 where t1.ctime>t2.ctime)
select * from table
where createtime=(
select min(createtime)
from table where colName = 'colValue'
) and colName = 'colValue'
select * from table where createtime=(select min(createtime) from table)
from tb t1
where not exists(select 1 from tb t2 where t1.ctime>t2.ctime)
select * from table_name where rowid = (select min(rowid) from table_name)
rowid 不知道行不行