Question

”sql分页为什么第一行数据始终都有“

Answer 1

limit 要从0开始搜索，而不是1。0才是第一条数据

追问

select TOP (12) goods_Id,goods_Name,goods_Price,goods_picture,
goods_MerchantID,Goods_cityid FROM goods WHERE goods_Id in
(select top 100 percent goods_Id from goods where goods_categoryID=80 and goods_Name like '%%' and goods_Id NOT IN (SELECT TOP (12*(2-1))
goods_Id FROM goods where goods_categoryID=80 order by goods_Pay desc) order by goods_Pay desc)

追答

第一页top pageSize,第二页 top pageSize*2,但前pageSize条记录被丢弃了,第二页的数据是从pageSize+1开始取的.

同理,第三页的数据查询了pageSize*3条数据,前pageSize*2条记录丢弃,只要pageSize*2+1到pageSize*3之间的数据...

Answer 2

把你写的SQL 写下来