方法一:
select * from (
select * from student where 1=1 order by stu_time
)
where rownum=1;
student所有数据:
查询结果:
方法二:
select t.* from (
select s.*,row_number() over(order by stu_time ) as rwnum from student s where 1=1
) t
where rwnum=1;
查询结果:
方法一:
select * from (
select * from student where 1=1 order by stu_time
)
where rownum=1;
student所有数据:
查询结果:
方法二:
select t.* from (
select s.*,row_number() over(order by stu_time ) as rwnum from student s where 1=1
) t
where rwnum=1;
查询结果: