» 2010-5-23 18:35:11 已被归档于 Sql
一个查询SQL:
查询第M条起的N条记录(形式分页)
SELECT TOP N *
FROM [0791idc_Product]
WHERE (ID NOT IN
(SELECT TOP N(页数-1) id
FROM [0791idc_Product]
ORDER BY id))
ORDER BY ID
比如这样就是查询第7条到12条记录
MS里好像没有LIMIT或行号
SELECT TOP 6 *
FROM [0791idc_Product]
WHERE (ID NOT IN
(SELECT TOP 6 id
FROM [0791idc_Product]
ORDER BY id))
ORDER BY ID