联合主键，取第m到第n条数据

[jjcl521]

有一个A表，字段 A1 A2 A3 A4...

A1 A2是联合主键

需求：查询A表第10条到第20条数据

[wwwwb]

有无唯一标识的字段，比如自增ID
select top 10 * from (select top 20 * from tt order by ID ) order by ID desc

[jjcl521]

[Quote=引用 1 楼 wwwwb 的回复:]

有无唯一标识的字段，比如自增ID
select top 10 * from (select top 20 * from tt order by ID ) order by ID desc
[/Quote]

没有唯一的表示，两个子都是联合主键，单个字段都有重复

[WWWWA]

必须加入自增ID才能排序

[jjcl521]

select * from A a where not exists(select top 10 * from A b where a.A1=b.A1 and a.A2=b.A2 order by A1,A2) order by A1,A2

我这样为什么取不出，除过Top 10 的数据
我查询的结果是空

[WWWWA]

关键是not exists，
select top 10 * from A b where a.A1=b.A1 and a.A2=b.A2 order by A1,A2
是存在记录的，当然没有返回记录

[ACMAIN_CHM]

你既然有主键，就按主键排序来操作。


select top 10 * from (select top 20 * from a inner join b on a.id=b.id order by 主键 ) order by 主键 desc