查询时间最晚的人的信息:
select *
from seller
where birthday=
(select max(birthday)
from seller)
查询第30到第40的人的信息:
select * from
(select row_number () over(order by id) as ID,* from table1) as tb
where ID>=30 and ID<=40
--whereID in(4,8) --只取出ID为4和8的信息
查询时间最晚的人的信息:
select *
from seller
where birthday=
(select max(birthday)
from seller)
查询第30到第40的人的信息:
select * from
(select row_number () over(order by id) as ID,* from table1) as tb
where ID>=30 and ID<=40
--whereID in(4,8) --只取出ID为4和8的信息