求SQL 找出时间最小的一行 create table test(userid varchar2(10),username varchar2(10),in_time date);怎么找出in_time时间为最小的一行?? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select * from test order by in_time where rownum<=1 select * from testwhere in_time in(select min(in_time) from test) select * from testwhere in_time =(select min(in_time) from test) select * from test order by in_time where rownum = 1 hdhai9451(☆新人类☆) 和 junqiang(蓝色海洋) 的答案是对的 select * from(select * from test order by in_time where rownum=1; select * from(select * from test order by in_time )where rownum=1; select * from testwhere in_time = (select min(in_time) from test);我觉得应该可以用=吧,子查只返回一个最小值 select * from test order by in_time where rownum=1 select * from test order by in_time where rownum<=1 SELECT TOP 1 * FROM test ORDER BY in_time select * from test order by in_time where rownum <= 1 帮我看一下这几个sql 怎么写? spool 导出数据导出数据的问题 超有难度的sql,200分奉上! 遇到error,请给位大虾解决一下啊,谢谢 一个关于sequence的奇怪问题,急!!!!请大家帮忙啦!! 如何用语句写出某用户的所有表与表的结构?? 当要查的字段内容为空时,怎么查询? 涉及到两个表的触发器问题 Oracle9I的帮助在哪? 帮个忙先! 求助:SQL语句的模糊查询?? 请帮忙查找Update此语句的错误
select * from test order by in_time where rownum<=1
select * from test
where in_time in(select min(in_time) from test)
where in_time =(select min(in_time) from test)
select * from test order by in_time
where rownum=1;
(
select * from test order by in_time
)
where rownum=1;
from test
where in_time = (select min(in_time)
from test);我觉得应该可以用=吧,子查只返回一个最小值