分页啊。每三条一页,然后不同的页显示在不同的地方或者取出来3条现在是A 取出来4-6显示在B 取出来7-10显示在C取4-6条记录的sql如下: use master go create table employees ( empid varchar(10), empname varchar(10), emppassword varchar(10) ) go insert into employees values('1','asdf','sdfsdf') insert into employees values('2','asdf','sdfsdf') insert into employees values('3','asdf','sdfsdf') insert into employees values('4','asdf','sdfsdf') insert into employees values('5','asdf','sdfsdf') insert into employees values('6','asdf','sdfsdf') insert into employees values('7','asdf','sdfsdf') insert into employees values('8','asdf','sdfsdf') go select top 3 * from employees where empid not in(select top 3 empid from employees) go
进入表格DataTable后,想取几条就几条啊你的问题问的大大的问题
取出来4-6显示在B
取出来7-10显示在C取4-6条记录的sql如下:
use master
go
create table employees
(
empid varchar(10),
empname varchar(10),
emppassword varchar(10)
)
go
insert into employees values('1','asdf','sdfsdf')
insert into employees values('2','asdf','sdfsdf')
insert into employees values('3','asdf','sdfsdf')
insert into employees values('4','asdf','sdfsdf')
insert into employees values('5','asdf','sdfsdf')
insert into employees values('6','asdf','sdfsdf')
insert into employees values('7','asdf','sdfsdf')
insert into employees values('8','asdf','sdfsdf')
go
select top 3 * from employees where empid not in(select top 3 empid from employees)
go