MSSQLSERVER中 如何实现 有选折 查询

[yunjava]

MSSQLSERVER中 如何实现 有选折 查询？
我想实现 只查询A表的40-50条记录 我应该怎么写语句
select * from a where ????

[skyboy0720]

有主键么？或者排序的字段！！给出你的数据库结构！！！

[yunjava]

是这样，没有定义主键。表中各列有username,password,xb(性别),zhiwu（职务),bumen(部门),tel(电话) rgdate(入岗时间) 排序是按照order by username 来排的 。
我想显示40-50条的记录
select * from a where order by username ????
应该如何查询？

[treeroot]

select top 10 * from
(select * from
(select top 50 * from a order by username as temp1)
order by username desc)
order by username

[treeroot]

最好这样：
select top 10 temp2.* from
(select temp1.* from
(select top 50 * from a order by username as temp1)
order by username desc as temp2)
order by username

[yunjava]

有错误 那为朋友还有好的方法？

[yunjava]

是这样，没有定义主键。表中各列有username,password,xb(性别),zhiwu（职务),bumen(部门),tel(电话) rgdate(入岗时间) 排序是按照order by username 来排的 。
我想显示40-50条的记录
select * from a where order by username ????
应该如何查询？

[libra_king]

关注！

[yMessiah]

其待ing...

[香芋元宇宙]

这句可以实现：
select * from A limit 40, 10

[香芋元宇宙]

写错了，应该是这句：
select * from A limit 39,10

[skyboy0720]

select id=identity(int,1,1),* into #t from a
select * from a where id between 40 and 50
drop table #t

[skyboy0720]

sorry:
select id=identity(int,1,1),* into #t from a
select * from #t where id between 40 and 50
drop table #t