如何得出数据表里第 7 至第 12 条记录?

2007-12-19 01:04:36 217 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

【KBrowser】基于 Kiwi/chromium 制作全新外壳，将 chromium 代码当作 webview 使用，实现可控核替换 chromium 其实只需几步巧妙的架构，就能拿来“换核”，甚至可以插件化，实现类似webview.apk 的效果。重新设计界面，不再是差不多的回声。而 Kiwi 基于 chrome 77 ，只有 50 MB。优势是兼容好、可安装扩展。阅读详情

用 select top 6 * From customer 可以得出 customer 表首 6 条记录, 哪有没有语句得出下一个 6 条记录(即数据表里第 7 至第 12 条记录)?

谢了.

...全文

银河麒麟鲲鹏aarch64架构安装docker和K8s 鲲鹏云服务器上安装docker-云社区-华为云 (huaweicloud.com) 这里我下载的版本是docker-18.09.3.tag docker 安装包地址：https://download.docker.com/linux/static/stable 配置system服务在github对应分支的contrib/init/systemd/ 下面，提供了对应的docker.service以及docker.socket文件，可以直接拷贝到本地文件使用：对应链接：https://github.c 阅读详情

flycrm

MS-SQL Server 34,876 成员 254,635 内容

+ 关注 + 加入社区

切换为时间正序

moyifeng 2007-12-19

打赏
举报



SELECT   TOP m  customer1.namefull,customer2.tel   

	FROM   customer1,customer2

	where customer1.custid not in 

		(select TOP  n customer1.custid 

			FROM   customer1,customer2   

			WHERE   customer2.custid=customer1.custid   

			ORDER   BY   customer1.setdate   DESC )

		and customer2.custid=customer1.custid

		ORDER   BY   customer1.setdate   DESC

这里你要的是第7-12条记录,n就等7-1为6,m是你要的记录数,7-12总共6条记录,所以为6.替换下就是你要的结果

flycrm 2007-12-19

打赏
举报

非常多谢楼上各位先.

各位工作顺利,恭喜发财!

hui_hui_2007 2007-12-19

打赏
举报

如果没有惟一字段，就只能通过临时表增加一个自增列了。
不过，楼主也可以在真实的表中增加一个自增列。这样总会有好处的。

hui_hui_2007 2007-12-19

打赏
举报



--注：必须要有惟一字段,这里假定col1是惟一字段。

declare @tb table (

	col1 varchar(3),

	col2 varchar(10)

)



insert into @tb

select 'b1','aaa' union all

select 'm2','bbbb' union all

select 'y3','cccc' union all

select 'c4','dddd' union all

select 'r5','eeee' union all

select 'u6','ffff' union all

select 'h7','gggg' union all

select 'n8','hhhh' union all

select 'v9','iiii' union all

select 'y10','jjjj' union all

select 'c11','kkkk' union all

select 'a12','llll' union all

select 'z13','mmmm' union all

select 'p14','nnnn' union all

select 't15','oooo' union all

select 'm16','pppp' 



select * 

from @tb

order by col1



--7-12

--(12-7)+1为6，所以为： top 6 *

select top 6 *

from @tb

where col1 not in (select top 6 col1 from @tb)

/*

col1 col2       

---- ---------- 

h7   gggg

n8   hhhh

v9   iiii

y10  jjjj

c11  kkkk

a12  llll



（所影响的行数为 6 行）

*/

hui_hui_2007 2007-12-19

打赏
举报





--注：必须要有惟一字段,这里假定col1是惟一字段。

--当然，为了好看，我的col1列是顺序的，其实无规律也可以

declare @tb table (

	col1 int,

	col2 varchar(10)

)



insert into @tb

select 1,'aaa' union all

select 2,'bbbb' union all

select 3,'cccc' union all

select 4,'dddd' union all

select 5,'eeee' union all

select 6,'ffff' union all

select 7,'gggg' union all

select 8,'hhhh' union all

select 9,'iiii' union all

select 10,'jjjj' union all

select 11,'kkkk' union all

select 12,'llll' union all

select 13,'mmmm' union all

select 14,'nnnn' union all

select 15,'oooo' union all

select 16,'pppp' 



--7-12

--(12-7)+1为6，所以为： top 6 *

select top 6 *

from @tb

where col1 not in (select top 6 col1 from @tb)

/*

col1        col2       

----------- ---------- 

          7 gggg

          8 hhhh

          9 iiii

         10 jjjj

         11 kkkk

         12 llll



（所影响的行数为 6 行）

*/

wuxinyuzhu 2007-12-19

打赏
举报



--给你个老土的办法 用一个临时表

SELECT       TOP       12   id=identity(int,1,1),    customer1.namefull,customer2.tel   into #    FROM       customer1,customer2       WHERE       customer2.custid=customer1.custid       ORDER       BY       customer1.setdate       DESC 

--查找第七行到十二行的数据

select top 5 namefull,tel from # order by id desc

fengxiaoxi 2007-12-19

打赏
举报

SELECT TOP 6 * FROM [TableName] WHERE ID NOT IN (SELECT TOP 6 ID FROM [TableName])
这个应该能实现你的要求把...

flycrm 2007-12-19

打赏
举报

如果我是从两个关联表里取记录,并且得按里面一个字段排序,

取前 6 条是这样:

SELECT TOP 6 customer1.namefull,customer2.tel FROM customer1,customer2 WHERE customer2.custid=customer1.custid ORDER BY customer1.setdate DESC

取 7 至 12 条的语句又是如何呢?
(按我里面两个表来写语句),因是新手, 多谢各位先了.

dawugui 2007-12-19

打赏
举报

--sql server 2005 可以用row_number函数解决.如下:

select * from

(

  select *,row_number() over(order by addressid) px from person.address 

) t

where px between 7 and 12

dawugui 2007-12-19

打赏
举报

取n到m条记录的语句



1.

select top m * from tablename where id not in (select top n id from tablename)



2.

select top m * into 临时表(或表变量) from tablename order by columnname -- 将top m笔插入

set rowcount n

select * from 表变量 order by columnname desc



3.

select top n * from 

(select top m * from tablename order by columnname) a

order by columnname desc





4.如果tablename里没有其他identity列，那么：

select identity(int) id0,* into #temp from tablename



取n到m条的语句为：

select * from #temp where id0 >=n and id0 <= m



如果你在执行select identity(int) id0,* into #temp from tablename这条语句的时候报错,那是因为你的DB中间的select into/bulkcopy属性没有打开要先执行：

exec sp_dboption 你的DB名字,'select into/bulkcopy',true





5.如果表里有identity属性，那么简单：

select * from tablename where identitycol between n and m

earthpea 2007-12-19

打赏
举报

如果你使用的是sql 2005的话，直接使用窗口函数就可以了，很方便，速度也很快

select sal from

(select row_number() over (order by sal) as rn,

sal

from emp) x

where rn between 7 and 12

flycrm 2007-12-19

打赏
举报

hui_hui_2007 (天行健) ,可不可给出些具体代码,多谢了.(如果不用存储过程)

中国风 2007-12-19

打赏
举报

select top 6 * from t where binary_checksum(*)not in(select top 6 binary_checksum(*) from t)

select top 6
*
from (select top 12 ID from t order by ID )TT
order by ID desc--通过排序规则来取
--有主键是直接引用主键not in

wangxuelid 2007-12-19

打赏
举报

1: sql2005使用
declare @t table (Row varchar(10),Val varchar(10))
insert into @t select '1','101'
insert into @t select '1','101'
insert into @t select '2','1'
insert into @t select '1','101'
insert into @t select '1','101'
insert into @t select '2','1'
insert into @t select '1','101'
insert into @t select '1','101'
insert into @t select '2','1'
insert into @t select '1','101'
insert into @t select '1','101'
insert into @t select '2','1'
insert into @t select '1','101'
insert into @t select '1','101'
insert into @t select '2','1'
insert into @t select '1','101'
insert into @t select '1','101'
insert into @t select '2','1'
select id_=row_number() over(order by row), * into #table from @t t where (id_<13 and id_>5)
select * from #table where (id_<13 and id_>5)
2: SQL2000使用
select * from ( select top 12 * from @t order by row ) t order by row desc

flycrm 2007-12-19

打赏
举报

到目前为止,moyifeng 所列出的正是我所找,非常多谢moyifeng,也非常多谢楼上各位.

hui_hui_2007 2007-12-19

打赏
举报

这个功能用存贮过程好实现，就是用临时表，增加一个自增列。因为加上自增列，序号就出来了。

flycrm 2007-12-19

打赏
举报

如果我是从两个关联表里取记录,并且得按里面一个字段排序, 且不想建临时表(因为数据量很大),有没有办法呢?

取前 6 条是这样:

SELECT TOP 6 customer1.namefull,customer2.tel FROM customer1,customer2 WHERE customer2.custid=customer1.custid ORDER BY customer1.setdate DESC

取 7 至 12 条的语句又是如何呢?
谢.

benbenkui 2007-12-19

打赏
举报

上面的不对，ORDER BY index DESC 应该在第二条语句中。

benbenkui 2007-12-19

打赏
举报



SELECT TOP 12 * INTO #tb FROM customer ORDER BY indexcol DESC

--indexcol 为索引列

SELECT TOP 6 * FROM #tb

benbenkui 2007-12-19

打赏
举报



SELECT px=identity(int,1,1),* INTO #a FROM customer

SELECT * FROM #a WHERE px>5 AND px<13

DROP TABLE #a

如何得出数据表里第 7 至 第 12 条记录?

相关推荐

如何得出数据表里第 7 至第 12 条记录?