sql语句怎样从数据库中查找某一条到某一条之间的记录
2个回答
展开全部
where 某条数据的字段名 between '值1' and '值2'
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
展开全部
不知道我有没有理解你的散祥意思
sqlserver数据库汪喊
select *from(
select Row_number()over(order by id) as rn,*from emp) as e
where e.rn between 15 and 20
oracle数据困掘野库
select*from (
select rownum as rn,a.*
from(select *from emp order by id)as a) as b
where b .rn between 15 and 20
sqlserver数据库汪喊
select *from(
select Row_number()over(order by id) as rn,*from emp) as e
where e.rn between 15 and 20
oracle数据困掘野库
select*from (
select rownum as rn,a.*
from(select *from emp order by id)as a) as b
where b .rn between 15 and 20
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
推荐律师服务：
若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询
