select top 10* from
(select deviceID,Licenseplat=min(Licenseplat),vehicletype=min(vehicletype),
owner=min(owner),ownertel=min(ownertel),driverName=min(driverName),
driverTel=min(driverTel),maxloadlength=min(maxloadlength),
maxloadwidth=min(maxloadwidth),transportationline=min(transportationline)
from logistics_carsInfo group by deviceID)lc
where Licenseplat not in (select top 20* from (select distinct Licenseplat from logistics_carsInfo) lcs)
这句sql是一页显示10条数据，并且不能重复，我写的是sql，但是要我写成存储过程，怎么写呢？写不来
------解决方案--------------------
搜索分页存储过程 懒得贴。
------解决方案--------------------
小F 那有通用存储过程 问他要一个...