如何获得数据表的21-31条数据? 如何获得数据表的21-31条数据? sql语句怎么写呢?谢谢~.~ 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 ID连续的select * from '表名' where id between 21 and 31 ID不连续的 select top 10 * from (select top 30 * from '表名') order by id desc ;with tas(select rowid = row_number() over (order by colname),* from ta)select * from twhere rowid between 21 and 31 --sql2005的with liangck as (select *,px=row_number() over(order by id asc) from tb)select * from liangck where px between 21 and 31 问大家一个很平常用到的问题-查询重复数据 关于distinct 问题 内联接与外联接的区别 求助:我启动服务管理器时出现了问题,想请假大家,谢谢! 请教一个问题:如果在一张表里,有多家机构号和证件号,我要找出哪些证件号是跨机构存在的 如何实现小计和合计 如何得到如下数据? 好久不来了,给大家送分:) 在VB里如何通过程序将sql server某张表的默认值等属性读出来。 存储过程同一时刻只能执行一次吗? SQL2005语法问题 请问:怎样获取硬盘中某个文件的大小?
select * from '表名' where id between 21 and 31
select top 10 * from (select top 30 * from '表名') order by id desc
as
(select rowid = row_number() over (order by colname),*
from ta
)
select * from t
where rowid between 21 and 31
with liangck as (
select *,px=row_number() over(order by id asc)
from tb)
select * from liangck
where px between 21 and 31