作者:拍友2602932873 | 来源:互联网 | 2023-05-18 07:22
createtabletest(useridvarchar2(10),usernamevarchar2(10),in_timedate);怎么找出in_tim
create table test(
userid varchar2(10),
username varchar2(10),
in_time date);
怎么找出in_time时间为最小的一行??
13 个解决方案
select * from test order by in_time where rownum<=1
select * from test
where in_time in(select min(in_time) from test)
select * from test
where 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 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
SELECT TOP 1 * FROM test ORDER BY in_time
select * from test order by in_time where rownum <= 1